Find and Replace

[Jonbob]

I have the following formula in cells c3-c7:

B3*0.75
B4*0.75
B5*0.75
B6*0.75
B7*0.75

I want to do a find and replace on these cells changing *0.75 to /2, yet all I get in these cells is "/2" and not the formula I want, b3/2. Can you do a find a replace for this type of formula? I know I can just fix 1 and copy down, but is there any way to do a find and replace?

Thanks,
Jonbob

 

[Tom Urtis]

The problem is that the multiplication operator is an asterisk which is also a wildcard.

In the Find What field of your Find and Replace dialog box, enter
~*0.75
that is, precede the *0.75 with a tilde (usually located to the left of the numeral 1 on most keyboards).

 

[Jonbob]

Great- is worked- thanks.