Mar 13 2019 10:59 AM
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?
Mar 13 2019 01:00 PM
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.