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.
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 ?
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.