Phone number data cleanup

Highlighted
Occasional Visitor

I have hundreds of phone numbers coming in from a data source in all different formats.  Ex. (111) 222-3333, 111-222-3333, 1112223333 ext. N/A, 111222333 ext. personal)  I need them all to be in the format of 1112223333.  How can I change them all to the same format quickly and efficiently?

1 Reply

One way of thinking about this is to remove all characters that are not numbers. A good example of how to solve this can be found at https://www.extendoffice.com/documents/excel/3244-excel-remove-letters-from-strings-cells-numbers.ht....

 

Hope this helps.