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