Excel question - removing hyphens from telephone number lists

Factual Questions
1

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

2

Did you try a search and replace?

3

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.

4

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))”.

5

An easier formula would be

=SUBSTITUTE(cell, “-”, “”)

6

Thanks, all. I will try these out.
Roddy