Thread: How do I remove a text character from an excel cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
  
Posts: 989
Default How do I remove a text character from an excel cell?
I have a lot of data that is in the format 123-4567. I need to convert this
to be 1234567. Does someone know how to do this with a formula?
Reply With QuoteReply With Quote