Thread: how do i remove telephone number hyphens from a list in Excel?
View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default how do i remove telephone number hyphens from a list in Excel?
=SUBSTITUTE(A1,"-","")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mediazoo" wrote in message
...
I have a long list of telephone numbers in an Excel spreadsheet that i
need
to remove the hyphons from. Do you have a quick formula for doing this?


Reply With QuoteReply With Quote