Finding country based on phone numbers

[jtklepp]

I have a list of mobile phone numbers from various countries. However, I do not know which country each entry is from. Ideally I would like to have a macro that looks at each number, compares to a global list of PSTN structure to determine which part of the phone number is the country code (generally the first 1-3 digits), and then put the country in a separate column.

I am certain all numbers are formatted correctly, so it is only a matter of finding out which part is the country code and putting a value for the country.

Anyone come across this one before?

 

[Shaikh Adnan]

The phone numbers will be entered randomly and I want a code which will fetch the country codes from the list and display the country code.

 

[Shaikh Adnan]

The phone numbers will be entered randomly and I want a code which will fetch the country codes from the list and display the country code.