How do I remove a text character from an excel cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Do you want a formula?

You could get rid of the "-" using edit>replace


Gord Dibben MS Excel MVP
 
Back
Top