Does ? work under excel search?

[harry]

Hi,

Wondering if there is any way to search/find the ? inside of a cell? It
does not work for me unless the ? is by itself in a cell. I need to dig out
this symbole from within a cell. For example, cells may have "abc?123" in
it and I need to find and delte it.
Is it feasible?

Thanks

 

[JulieD]

Hi Harry

in the find what box type
~?
in the replace with box leave blank
click on options and ensure that match entire cell contents is not checked

run the replace

Cheers
JulieD

 

[Frank Kabel]

Hi
try searching for
~?

 

[harry]

What if I really meant to replace or search ~? instaed of ?
What caused microsoft to implement this change? I remember office 2000 can
do a straight ? search.

Thanks for you and Frank's help.

 

[Dave Peterson]

I think you're remembering incorrectly.

To search for ?, use ~?
to search for *, use ~*
to search for ~, use ~~

So to search for ~?, use: ~~~?

~~ for the tilde and ~? for the question mark.

 

[Myrna Larson]

You must have had a custom variant of Excel 2000 <vbg>.