Thread
:
Simple Search and Replace Question
View Single Post
#
3
Nick Hodge
Posts: n/a
Rebecca
Prefix with a single tilde (~) so you will have ~* to find the *
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Rebecca" wrote in message
...
Hi. I am searching and replacing various characters in an Excel column.
I
need to delete all the asterisks (*) in this column. How do I do this?
That
is, how do I make Excel "think" the asterisk is NOT a wildcard characteer
but
a real character that I want to get rid of?
Reply With Quote