Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

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?


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

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.

Barrie


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

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.