Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I find and replace a question mark in Excel?
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. |
#2
|
|||
|
|||
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 :-) ------------------------------*------------------------------*---------------- "Ranpalandil" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Find and Replace is changed to previovois ver.-awful!! | Excel Discussion (Misc queries) | |||
find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
Excel - Find & Replace text in a string | Excel Worksheet Functions | |||
find and replace links in Excel 2003 | Excel Worksheet Functions | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) |