Thread: remove text with format code for phone numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
  
Posts: 159
Default remove text with format code for phone numbers
What format code is needed to remove the "()", spaces and "-" from "(555)
555-5555" that would look like "5555555555" ?

also from "555 555-5555" into "5555555555"
and "555 555 5555" into "5555555555"
Reply With QuoteReply With Quote