View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allewyn
 
Posts: n/a
Default How change "535?4090" to "535-4090" using replace

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? :)