Excel Search Queries
Microsoft Excel uses a custom format for search queries.
Wildcards
Excel supports the following wildcard patterns for queries.
Pattern |
Meaning |
Example |
? |
Any single character |
sm?th matches smith and smyth |
* |
Any number of any character |
*east matches Northeast and Southeast |
Escaping Literals
To use a literal question mark (?), asterisk (*), or tilde (~) in a query, escape using a single tilde (~). Hello~? matches Hello?.