How to find a question mark (?) or other wildcard symbol when searching in Excel

Failed solution:

You use Find & Replace to try and find the question mark (or other symbol like percentage % or asterix *) only to realise that Excel considers it to be a wildcard character (i.e. like a blank tile in scrabble, it can mean absolutely anything) and so every single letter in every cell gets highlighted.

Actual solution:

You need to ‘escape’ the character and to have Excel treat it like a real symbol not a wildcard by placing a ’tilde’ symbol (~) in front. As an example with the question mark, the picture below shows its use:

Excel find and replace wildcard with tilde

Leave a Reply

Your email address will not be published. Required fields are marked *