Formatting phone numbers in Excel

  • Thread starter Thread starter Nancy Lee
  • Start date Start date
N

Nancy Lee

How do I change
(808) 123-4567
to
808-123-4567

I tried using custom formatting with ###-###-####, but it
won't apply unless I manually delete the parentheses.

I have over 35,000 phone numbers to change, please help!

Thanks,
Nancy Lee
 
Assuming the numbers are in col A, A1 downwards, try putting in B1
:=REPLACE(TRIM(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")),4,1,"-")

Copy down col B
Then select col B and copy>paste special>values>ok in place to remove the
formula
 
Back
Top