Simple Search and Replace Question

R

Rebecca

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?
 
A

Aladin Akyurek

Rebecca said:
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?

Find What: ~*

instead of just: *
 
Top