computer with excel topic

[kertaker]

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?

 

[RoryA]

Try filtering on ~? instead.

 

[Taul]

thats odd!
I just tried filtering a column of question marks and it works fine in 2003 & 2010.
Are there any settings that could switch on or off the wildcard thingy