Forum Discussion
Phone number data cleanup
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.html.
Hope this helps.
