Does ? work under excel search?

H

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
 
J

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
 
H

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.
 
D

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.
 
Top