Wildcard
Also known as · Wildcards
* stands for any run of characters (including none), ? for exactly one character, and ~ escapes them. They work on text only and are not case sensitive.
When to use
Patterns such as a* (starts with a), *Haifa* (contains Haifa) and a??? (a four-letter word starting with a) work in AutoFilter text filters, Advanced Filter criteria, database-function criteria and COUNTIF. To find a literal asterisk, put ~ in front.
See Lec 01.