Remove dashes from phone numbers in a spreadsheet

AAH · Jul 25, 2008

I am trying to remove the dashes from between phone numbers in a spreadsheet
and then place a one (1) in front of the number when the dashes has been
removed.

Eg. 876-176-2344 ... change to 18761762344

Teethless mama · Jul 25, 2008

=1&SUBSTITUTE(A1,"-","")

AAH · Jul 25, 2008

Thanks it worked like a charm ...
--
AAH

Teethless mama said:
=1&SUBSTITUTE(A1,"-","")

Teethless mama · Jul 25, 2008

You're Welcome!

AAH said:
Thanks it worked like a charm ...