Guide to 20 Worksheet Functions that Use Wildcards

A limited number of Excel worksheet functions can use wildcard characters to filter results. Here a guide to using them.

934

A limited number of Excel worksheet functions can use wildcard characters to filter results. Here a guide to using them.Excel offers nearly 20 worksheet functions that support the ability to use wildcards in their arguments. You’ll find them listed below, with links to Microsoft’s help topic about each of them.

And here are the characters you can use to filter characters in those functions:

 USE…  TO FIND….
? (question mark) Any single character.
For example, “Bl?ck” finds either “Black” or “Block”
* (asterisk) Any number of characters.
For example “North*” finds “North”, “Northeast”,
and “Northwest”. And “(*)” finds any content enclosed by parentheses.
~ (tilde) followed by ?, *, or ~ A literal question mark, asterisk, or tilde. For example…
…To find “West*” use “West~*”
…To find “West?” use “West~?”
…To find “West~” use “West~”
…To find “West~?” use “West~~?”