Find and Replace Wild Card Characters

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
 
J

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.
 
G

Gord Dibben

Jeannie

In Excel use the ~ Found above the TAB key.

e.g. ~? or ~*

Gord Dibben XL2002
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing a repeated words 0
Find/Replace specific indent 1
Custom toolbar button for search and replace 1
Eliminate wild characters 5
Word macro that can call cells out of Excel for a find and replace 0
Word- Find and Replace 1
Mass Changes in Excel using Wild Cards or other 3
Prompt For Replace in Selection And More... 0

Top