how do i search for cells containing a question mark (?)

S

sokevin

hi,


i want to search for or autofilter cells containing a "?" (questio
mark)

someone has previosly put

1234-00-222?
1234-00-223?

in a cells

where the question mark represents that he is not sure at the time o
input about the number

now i need to filter all the cells that contain a ? so that i ca
amend or confirm those numbers.


however when i do a FIND (ctrl F) for ? or a autofilter for cell
containing ? it doesnt find or filter anything.


i also tried searching for "?" but doesn work.


does anyone have a solution.


thanks :
 
L

Laura Cook

In AutoFilter, choose Custom, and then select "Contains" (second to last
option in the drop down). Enter a "?" in the box to the right and hit OK.
 
D

Debra Dalgleish

Type a tilde ( ~ ) before the question mark, e.g. ~?

It's on the key to the left of the number 1 key, above the Tab key.

Use the ~? in a custom AutoFilter, or in the Find box.
 
R

RagDyer

Acually Debra, to be picky,
~?
returns *only* a solitary question mark.
To answer the OP,
*~?
is what has to be entered to find 1234-00-232?.
And to find the question mark anywhere,
*~?*
is needed.
--

Regards,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Type a tilde ( ~ ) before the question mark, e.g. ~?

It's on the key to the left of the number 1 key, above the Tab key.

Use the ~? in a custom AutoFilter, or in the Find box.
 
D

Debra Dalgleish

The OP said:

"however when i do a FIND (ctrl F) for ? or a autofilter for cells
containing ? it doesnt find or filter anything."

I assumed that 'contains' was selected as the operator in a custom
autofilter. In that case, no asterisks are required.
 
S

sokevin

what does the ? normally stand for in a search query

i know the asterix * usually means "anything" or "all"


thanks :
 
L

Leo Heuser

sokevin > said:
what does the ? normally stand for in a search query

i know the asterix * usually means "anything" or "all"
Click to expand...
Using ? means: Search for a single character like in
me?t.
 
Top