MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do you search for ("Find") an asterisk?

Posted by Chris Rock on August 29, 2001 12:24 PM

Using ctrl+F ("find"), it's impossible to find cells that contain a plain asterisk.

Any Ideas on how to do this?

Posted by Barrie Davidson on August 29, 2001 12:28 PM

Use the tilde(~) before the wildcard character to search for. For example, if you want to find "*" using CTRL+F, put ~* in the "Find What" box.


Posted by IML on August 29, 2001 12:29 PM

Type tilde (~) before your asterick in the find box. This tells excel you are looking for the actual character, not a wild card such as * or ?

good luck