Ctrl+F to find question marks in Excel 2

[RiverGuy]

I have a workbook where I have denoted some items with question marks. Now, I'm trying to find these items using Ctrl-F and the criteria being a question mark. However, Excel seems to interpret this as a wild card, and it is stopping on every cell. I've tried putting double quotes around the question mark in the find/replace dialog box to no avail.

Does anyone know how to search for a question mark without resorting to VBA?

Thanks

 

[AnotherHiggins]

In the Find What field, type in a [~] (tilde) before the question mark.

That tells Excel that you want to search for the literal character "?" rather than a wild card.

The tilde is at the top left of a standard American keyboard, to the left of the [1].

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[RiverGuy]

Perfect, thanks!

 

[Caz59]

If you press Ctrl_F then also expand the Options box and there you will see a tick box that asks if you want to find the identical character.
Good luck!
Caz

 

[AnotherHiggins]

RiverGuy:

Caz: I don't see that. I've checked 2003 and 2007. There's "Match Case", but that doesn't work.

What version are you?



[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

John, you enlightened me! ==> [purple]*[/purple]

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}