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.