Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I search without wildcards?
Hi, I'm trying to perform a search in a worksheet containing wildcard
characters (? and *) and I need to be able to find cells with the wildcard characters themselves, e.g. A1: What is your name? A2: Your rating is ***** A3: This cell contains no wildcards. If I press Ctrl+F (Find) and search for "?", it matches any single character (rather than the ? character in cell A1). If I search for "*", it matches any cell with values in (rather than the any of 5 stars in cell A2). Is there a way of disabling wildcard matching or "escaping" the wildcard characters themselves? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
CAN YOU DYNAMICALY CHANGE VLOOKUP SEARCH RANGE? | Excel Discussion (Misc queries) | |||
How do i build a search table in excel | Excel Worksheet Functions | |||
build a search tool in excel | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) |