I probably wasn't saying what I meant
Ok, let me try explaining this again to be complete:
772?8155
773?4006
772?1927
773?8250
770?9553
858?1911
245?3080
772?8527
776?2755
608?3823
This column has "?"s and I want "-"s instead. There are different prefixes
so that's why I tried wild cards to get where I am now.
I understand what you mean by using tilde but here's what happens
Replacing *~?* with *-* gives *-* in the cells
Replacing *~?* with *- gives *- in the cells
Replacing *?* with *-* wipes out the sheet (dashes everywhere)
Replacing ? with - crashed Excel .
Should I be replacing each prefix separately or is there a way to do them
all at one time?

"Dave Peterson" wrote:

Try ~?
(tilde question mark)

That tilde tells excel that you don't want the wild card for a single character
(?), you really want the question mark itself.

Same if you have to change an asterisk (* becomes ~*) or the tilde (~ becomes
~~).



Allewyn wrote:

Column of 1000 phone numbers. I've managed to eliminate area code using
replace with wildcards but can't seem to change the ? to a dash. Everything
I try completely messes up the sheet and I have to undo. Even had to restore
once! Gah! Any help out there? :)

--

Dave Peterson