Home

Phone number data cleanup

Highlighted
hazouz
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies