Thread: Remove dashes from phone numbers in a spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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
Reply With QuoteReply With Quote