How to find or replace asterisk(*) and question mark(?) in Excel?

Asterisk and question mark are excel’s wildcard characters. If you try to search or replace them in excel they won’t show up. Like if you ever try to replace the * in a formula within a cell with Blank, your whole cell will go blank. To overcome this problem, you need to add tilde(~) key before the multiplication sign(*) or question mark (?) sign in find and replace box.