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.

Appears in

No references yet.