again...Office.Jnr...is the factor a number or a cell ref (e.g. A1,X1....) ?
or a pure number 123....Aren't you sure if it is after "*" or after "=".....?

"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