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

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?
 
R

Rick Rothstein \(MVP - VB\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing dashes from ISBN's while still keeping 1st number (zero) 3
Remove dash(s) 9
select a string of characters 7
Remove punctuation mark, Split cells & average accross column 4
How do I create a formula to remove dashes? 6
Numbers Converted to Text - Last Digit Replaced by Zero 14
How do I delete dashes from a phone number xxx-xxx-xxxx in Excel? 3
How do I change date format m/d/yyyy to mmddyyyy toremove the dash 1

Top