Types of Excel Wildcards

Asterisk (*):

• Matches zero or more characters.
• Example: Ap* matches any text starting with "Ap."

Question Mark (?):

• Matches exactly one character.
• Example: T?m matches "Tim" or "Tom," but not "Tammy."

Tilde (~):

• Escapes wildcards.
• Example: File~* matches the literal text "File*," not "Files."
• Example: "File~*" matches "File*" but not "File123" or "FileABC."