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

"jwang036" wrote:

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.

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

On Jul 23, 10:33*am, jwang036
wrote:
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.