ExcelBanter - Remove dashes from phone numbers in a spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Remove dashes from phone numbers in a spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/196259-remove-dashes-phone-numbers-spreadsheet.html)

AAH

Remove dashes from phone numbers in a spreadsheet

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

--
AAH

Teethless mama

Remove dashes from phone numbers in a spreadsheet

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

"AAH" wrote:

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

--
AAH

AAH

Remove dashes from phone numbers in a spreadsheet

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

"Teethless mama" wrote:

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

"AAH" wrote:

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

--
AAH

Teethless mama

Remove dashes from phone numbers in a spreadsheet

You're Welcome!

"AAH" wrote:

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

"Teethless mama" wrote:

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

"AAH" wrote:

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

--
AAH

All times are GMT +1. The time now is 05:51 AM.