Wildcard characters
The following wildcard characters can be used as comparison criteria for text filters, and when searching and replacing content.
| Use | To find |
|---|---|
| ? (question mark) | Any single character
For example, sm?th finds "smith" and "smyth" |
| * (asterisk) | Any number of characters
For example, *east finds "Northeast" and "Southeast" |
| ~ (tilde) followed by ?, *, or ~ | A question mark, asterisk, or tilde
For example, fy06~? finds "fy06?" |
See also:
- COUNTIF
- COUNTIFS
- Database functions
- Filter by using advanced criteria
- Filter data in a range or table
- MATCH
- SEARCH, SEARCHB
- SUMIF
- SUMIFS
- VLOOKUP