Add a tilde "~" in front of the asterisk.
That changes the asterisk from a wildcard character to just an asterisk.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Office Jnr"
wrote in message
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