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.
Leave a Reply