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

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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?
 
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
 
Back
Top