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
? wildcard character represents any single character.
* wildcard character represents any count of characters.
~ wildcard character assists in identifying the
* wildcard characters.