Thread: Need to change numbers with dashes to numbers with no dashes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cheryltraining cheryltraining is offline
external usenet poster
  
Posts: 1
Default Need to change numbers with dashes to numbers with no dashes
The spreadsheet we're working has social security numbers and phone numbers
with dashes included. Need to remove dashes and not lose the leading zero in
the SSN.
Reply With QuoteReply With Quote