Thread: how do i remove telephone number hyphens from a list in Excel?
View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default how do i remove telephone number hyphens from a list in Excel?
One way is to highlight the column, then do Edit Replace put - in the
"Replace" box and leave the "replace with" box empty, then press ReplaceAll


Vaya con Dios,
Chuck, CABGx3


"Mediazoo" wrote:

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