Phone number data cleanup

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


Hope this helps.