if I just lookup 12 it could replace all the other figures on the spreadsheet
thar are just 12 but are not multiplying anything. Lets say for example I
had a figure 12*12 and I wanted to put in multiplied by 21 - 12*21. It would
end up 21*21. I think this is what Biddulph meant as well.

"Gord Dibben" wrote:

I don't know if/why you are actually including the quotes and the * in your
replace, but try just entering the numbers alone.

Assuming formula is =A1*12

Replace what: 12

Replace with: 21

Replace.

Will now have =A1*21


Gord Dibben MS Excel MVP


On Sat, 11 Nov 2006 14:51:01 -0800, Office Jnr
wrote:

Yes I have tried this: eg in "A*12*" Find *12 Replace with *21 instead of
giving me A*21 it replaces the whole cell content with just *21

"Rookie 1st class" wrote:

Have you considered Find/Replace? in the edit menu?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y