Thread: In Excel, change phone from 555-555-5555 to 5555555555?
View Single Post
  #5   Report Post  
 
Posts: n/a
Default
Try the Substitute function

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

HTH
RES
Reply With QuoteReply With Quote