I am working on a solution that has contacts with phone numbers from around the world. About 80% of them are US phone numbers and the rest of them are international. Currently there is no consistency to how the numbers are entered. This is what I am trying to clean up. I also want to implement a system moving forward so there is a uniform appearance to the numbers.
I have found some great custom functions that can handle reformatting phone numbers but how do you identify and deal with international numbers? One of the main problems that I am running into is that when user is entering the phone number I don't yet know the country of origin.