Replace mutiply sign *

[jwang036]

I need to replace the * sign with something else. If I replace * with say /,
not only * sign but everything will be replace. Anyone knows how it can be
done? Thanks.

 

[Mike H]

Hi,

Put a Tilde in front of it and it will only replace the character and not
behave like a wildcard

~*

Mike

 

[Pete_UK]

The asterisk is used as a wildcard character in Excel. To replace just
the *, you need to preceed it with the tilde symbol ~, like this:

Find what: ~*
Replace with: /
click Replace all.

Hope this helps.

Pete