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

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

Gord Dibben

Do you want a formula?

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting Data from a string of text in a cell 4
Insert a character into a string 3
Data format 2
Remove the char from right 2
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
how to remove specific characters from a text field 3
How to return unique values only 4
Find/Replace Select Numbers in a Cell 3

Top