Find/Replace forumula help

J

jimville123

HI, I have a formula such as =3*3.3, 4*3.3, 5*3.3 and so on...howeve
now i want to replace the 3.3 factor with 1.3 in multiple cells usin
Find/Replace....i tried that but it replaces the entire value of let
say 3*3.33 with just *1.3. How should i go about this.

Basically i need to find a certain factor and replace it with anothe
factor in formula worksheet using find/replace.


thank
 
B

Bernie Deitrick

Jim,

Since you are looking for a wildcard character, you need to preceed it with
a tilde in the replace:

Find What:
~*3.3

Replace With:
*1.3

HTH,
Bernie
MS Excel MVP
 
P

Pete McCosh

Jim,

I'm guessing you tried to replace "*3.3" with your new
factor? Replace treats * as a wild card representing any
number of characters and so replaces the whole string.

To change your formula, just do replace "3.3" with "1.3".

Another approach might be to make your formula =3*$A$1
then change the value in cell A1 whenever you want to
alter the results.

Cheers, Pete
 
Top