Wildcard Characters

* (Asterisk)

This represents multiple characters.
For example Ex* will identify Excel, Example, Expert etc.

? (Question Mark)

This represents a single character.
For example We?k will identify Week and Weak.

Identifying Wildcard Characters (VBA)

In VBA this can be done by placing these characters inside square brackets [ ].

Identifying Wilcard Characters (Excel)

In Excel this can be done using the tilde (~) character as a prefix.