Ask Your Question

calc find & replace for formulas [closed]

asked 2018-01-29 19:08:53 +0200 gravatar image

I have a spreadsheet with a lot of rows. After being created, I have found that I need to change the formulas in all the cells. For example, I have a formula as follows: =F37*$D$2

What I need to do is change this to the following: =round(F37*$D$2,2)

Is there a way I can do this with find & replace?????

Thanks, Rich Ramik

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by
close date 2018-01-30 16:38:26.212251

1 Answer

Sort by » oldest newest most voted

answered 2018-01-29 19:24:27 +0200

JohnSUN gravatar image

It seems to me, Rich, that you're looking for something like this

Change Formula

Here the first asterisk means "any digits" and the second (with a backslash) - the multiplication sign

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-01-29 19:08:53 +0200

Seen: 149 times

Last updated: Jan 29 '18