How do I remove non-numerical charaters from a string?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 23 May 2008 16:02 GMT

I have data formatted like 038-1439-00 and I would like to remove the dashes
so that the cell reads 038143900. Is there a formula in Excel that can strip
out the dashes?

Reply to this Message

Gary''s Student - 23 May 2008 16:21 GMT

=SUBSTITUTE(A1,"-","")

Signature

Gary''s Student - gsnu200787

Reply to this Message

Steve - 23 May 2008 16:30 GMT

Perfect - THANKS!

> =SUBSTITUTE(A1,"-","")

Reply to this Message

Rick Rothstein (MVP - VB) - 23 May 2008 16:22 GMT

I may be missing something in your question, but if you have the cells
"formatted" to show numbers with dashes, then just change the cell's format
to not show them.

Rick

>I have data formatted like 038-1439-00 and I would like to remove the
>dashes
> so that the cell reads 038143900. Is there a formula in Excel that can
> strip
> out the dashes?

Reply to this Message