Thread: telephone number format change in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default telephone number format change in Excel
I have telephone numbers that are formatted as (###) ###-####.
I need a formula to change the format to ###-###-####.
Also need the same for telephone numbers that are formatted
as # (###) ###-####.

Give this formula a try...

=SUBSTITUTE(IF(LEFT(F1,1)="(",REPLACE(F1,1,1,""),S UBSTITUTE(F1," (","-")),")
","-")

Rick

Reply With QuoteReply With Quote