Find Wildcards like Asterisk, Question Mark

Having a hard time doing a Find or Find and Replace for question marks (?) in your spreadsheet? This is because “?” is a Wildcard. Wildcards are used to represent one or more characters of text. Often they are used in functions (Vlookups) or data tools (Find and Replace).

To search for wildcards, simply place a tilde (~) directly in front of the wildcard. This tells Excel to treat the wildcard as an actual question mark (?), asterisk (*), or tilde (~).

Here are a few examples:

To find ? in a spreadsheet enter ~? in the find box.

To find ~ in a spreadsheet enter ~~ in the find box.

To find * in a spreadsheet enter ~* in the find box.

[table “wildcards” not found /]

Leave a Comment