I am trying to match a phone number(~4500 phone numbers) to a list of country codes in excel to know the country. the problem is that I want to match the first x characters of the phone number to the country code (where x is the length of the country code in the list) as not all the country codes have the same length (Example. US:1 UK: 44 Jordan:962, UAE:971).
Phone Numbers Column looks as below:
447789205094
919445356808
97156613071
Country Code sheet contains in two columns
[TABLE="class: text_table"]
1
[/td]USA
[/td]44
[/td]UK
[/td]91
[/td]India
[/td]971
[/td]UAE
[/td]973
[/td]Bahrain
[/td]
[/TABLE]
I need to mark each number with the country name.
Then, check this country name with country mentioned in address field.