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

M

Mark

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?
 
G

Gord Dibben

Do you want a formula?

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


Gord Dibben MS Excel MVP
 
Top