Excel uses * (asterisk) to represent any number of characters and ? (question mark) to represent exactly one character as wildcards. For example, 'Sm*' matches 'Smith', 'Small', etc. while 'Sm?th' matches 'Smith' but not 'Smyth'. Characters like <, >, ^, /, +, - are not Excel wildcards.