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 /]