How to Search for Question Mark or Asterisk in Microsoft Excel 2016 ?

When working with Find and Replace dialog box in Microsoft Excel 2016 , you can use the wild characters ? and * .

The wild character ? matches any single character whereas the wild character * matches any number of characters.

What will you do when you want to search for something that has ? or * ? .

How to Search for Question Mark or Asterisk in Microsoft Excel 2016 ?

Assume that you want to search for a string *NIL* . In this case , you can use the tilde(~) symbol followed by the search string to search for it.

~*NIL~*

Leave a Reply