Straight From our Nerdery

How to search for special characters in Excel

Here's a problem I had - I used the * (asterisk) in certain cells that contained notes. Later I needed to search for all of the cells that had the *. The problem is that the asterisk is a special wildcard character and the result of using it in Find returned all the cells of the spreadsheet.

The answer is in a Microsoft Help and Support article: Article ID: 214138 - preceed the special character with a tilde (~). I used this to find what I needed by searching for ~*. If you need to search for the tilde character, type ~~ in the Find dialogue. What ever special character for which you need to search just preceed the character with ~.

Say something!

Are you human? If so, please type the word you see below: