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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I remove a text character from an excel cell? (https://www.excelbanter.com/excel-worksheet-functions/114303-how-do-i-remove-text-character-excel-cell.html)

Mark

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?

Don Guillett

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

editreplace

--
Don Guillett
SalesAid Software

"Mark" wrote in message
...
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?

Carim

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

Hi Mark,

=substitute(a1,"-","")

HTH
Cheers
Carim

Gord Dibben

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

Do you want a formula?

You could get rid of the "-" using editreplace

Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 05:35:02 -0700, Mark wrote:

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?

All times are GMT +1. The time now is 02:52 AM.