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
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote