Find Wildcards like Asterisk, Question Mark

August 15th, 2004 | Categories: General | Tags:
-->

I had a hard time today doing a find for all of the question marks ? in my spreadsheet. This is becuase Excel treats this as a wildcard. To search for wildcards just put a tilde ~ in front of your search.

Here are a few examples:

To find ? in a spreadsheet enter ~? in the find box.

To find ~ in a spreadsheet enter ~~ in the find box.

To find * in a spreadsheet enter ~* in the find box.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
No comments yet.