View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dino Dino is offline
external usenet poster
 
Posts: 35
Default 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?