How do I search without wildcards?
Use ~* and ~? to search
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Dino" wrote in message ...
| 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?
|