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

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

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

- - How do I remove non-numerical charaters from a string? (https://www.excelbanter.com/excel-worksheet-functions/188669-how-do-i-remove-non-numerical-charaters-string.html)

Steve

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

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?

Gary''s Student

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

=SUBSTITUTE(A1,"-","")
--
Gary''s Student - gsnu200787

Rick Rothstein \(MVP - VB\)[_503_]

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

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

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

Steve

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

Perfect - THANKS!

"Gary''s Student" wrote:

=SUBSTITUTE(A1,"-","")
--
Gary''s Student - gsnu200787

All times are GMT +1. The time now is 07:00 PM.