Mike Drillinger · March 16, 2009
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 ~.