For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Wildcards

Guide to Using Wildcards in Excel Worksheet Functions

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


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

You can use the following characters to filter characters in wildcard 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~~?"

Other Help

If you're looking for additional help with your formulas, I can help you in three ways. To learn more, see Excel Training, Coaching, and Consulting.

Charley's SwipeFile charts


Free Excel Dashboards