Tom’s Tutorials For Excel: Finding and Replacing Wildcards

Tom’s Tutorials For Excel: Finding and Replacing Wildcards

In this previous Tom’s Tutorial blog post, I showed an example of using wildcards in formulas. Today’s Tutorial shows how to find and replace wildcard characters themselves on your worksheet.

To review, in Excel, a wildcard character is either the question mark ?, the asterisk *, or the tilde ~.
The ? wildcard character represents any single character.
The * wildcard character represents any count of characters.
The ~ wildcard character assists in identifying the ? and * wildcard characters.

These examples show the tilde character as the key to finding and replacing wildcard characters.