Thread: How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rowland Rowland is offline
external usenet poster
  
Posts: 18
Default How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?


With a formula its

SUBSTITUTE(A1,"-","")

where xxx-xxx-xxxx is in cell A1


ARADER wrote:
How do I delete dashes from a phone number xxx-xxx-xxxx in Excel?
Reply With QuoteReply With Quote