Replace mutiply sign *

  • Thread starter Thread starter jwang036
  • Start date Start date
J

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.
 
Hi,

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

~*

Mike
 
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
 
Back
Top