This raises a new question - how do I search for "~"? Do I use "~~"?

Thanks for the quick response, either way.

"Niek Otten" wrote:

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?