Find and Replace Wild Card Characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can use the / in front of an * or ? in MS Word to
replace these wild card characters but it doesn't work in
Word. I have tried using the char equivalent and holding
down the alt key and entering the ascii value but with no
success. I'm pretty sure I could probably use some vba
function to do this, but I have many clients that ask me
how to do this. Is there any simple way to do this in
Excel. Please Help!!!

Jeannie Flores
 
Hi Folks,

Never Mind, I found the answer, and just in case someone
else needs it, the answer is to put a ~ character in
front of the * or ?.

Thanks.
 
Jeannie

In Excel use the ~ Found above the TAB key.

e.g. ~? or ~*

Gord Dibben XL2002
 
Back
Top