I receive a set of data that includes telephone numbers in the format 000-000-0000. I need to convert this column to just 10 digits without the hyphens.
Is there an Excel function that can do this?
Roddy
I receive a set of data that includes telephone numbers in the format 000-000-0000. I need to convert this column to just 10 digits without the hyphens.
Is there an Excel function that can do this?
Roddy
Did you try a search and replace?
Do a search and replace, with the ‘-’ as what you’re searching for and the replace field blank.
Just tested this and it worked just fine.
If for some reason you can’t do a find&replace, just use something like “=Concatenate(Left(a2, 3), mid(a2, 5, 2), right(a2, 4))”.
An easier formula would be
=SUBSTITUTE(cell, “-”, “”)
Thanks, all. I will try these out.
Roddy