How do I find and replace a question mark in Excel?

G

Guest

I have a range of cells with a single question mark ?, Y or N. I can't filter
with the question mark since Excel thinks it's a wild card. I wasn't aware of
this when I set up the spreadsheet. So I would like to replace the question
marks with something else, but this still presents the same problem. How can
I specify that I mean a question mark and not a wild card?

Thanks.
 
K

Ken Wright

use ~? instead and this will tell Excel to look for a ? as a ? and not as a
wildcard.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and replace ? 9
find replace excel remove single character 5
Find and Replace Command Using Wildcard Help 1
Finding and deleting question marks 3
Question Mark in a box 14
how do I use macro to find and replace unicode characters 6
Advanced Find and Replace Question 3
Find and replace paragraph marks in Excel 1

Top