Thread: How can I remove extra characters from a list- phone numbers in ex
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How can I remove extra characters from a list- phone numbers in ex
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"( ",""),")","")," ",""),"-","")


"Sarah HK" wrote:

I have a long list of phone numbers that I need formatted as just numbers,
with no characters or spaces? Is there a formula for this?
Reply With QuoteReply With Quote