Find Wildcards like Asterisk, Question Mark
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!
Get answers right away at our AE Excel Support Forums!
Leave a comment
| Trackback


