Use wildcard characters as comparison criteria for text filters and when you’re searching and changing content. These can likewise be utilized in the Conditional Formatting rules that utilize the “Format cells which contain particular text” criteria.
For more about using wildcard characters with the Find and Change features in Excel, see Discover or change text and numbers on a worksheet.
|
Use |
To discover |
|---|---|
|
? (question mark) |
Any single character |
|
* (asterisk) |
Any variety of characters |
|
~ (tilde) followed by?, *, or ~ |
An enigma, asterisk, or tilde |
Use wildcard characters as comparison requirements for text filters, and when you’re searching and replacing material. This feature allows you to discover values that share an easy pattern. These characters can be the asterisk (*), the enigma (?), and the tilde (~).
