Wildcard characters

The following wildcard characters can be used as comparison criteria (criteria: Conditions you specify to limit which records are included in the result set of a query or filter.) for 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, fy91~? finds "fy91?"
Applies to:
Excel 2003