Search excel for character *

How do I search in excel for a string with *  ( For example  column A has a value  *a . The problem I have is when I look for *a , it takes me thru all cells with value a in it
Sam OZAsked:
Who is Participating?
 
AlanConsultantCommented:
Hi,

Search for tilde-star then the rest of the string:

~*a

Open in new window



You are using the tilde to say that the next character is a literal:

https://support.microsoft.com/en-nz/help/214138/how-to-find-and-replace-tildes-and-wildcard-characters-in-excel

Alan.
0
 
Sam OZAuthor Commented:
thanks. Just curious , what if I am searching for tilda ( I don't need it now)
0
 
AlanConsultantCommented:
Then you would search for:

~~


Alan.
0
 
Bharat BhushanSolution ManagerCommented:
That's very interesting. Thank you so much for sharing.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.