Good day,


I have a sheet1 that has the following two columns: column 1 = Country name, column 2 = Dialling code e.g:

Column 1 Column 2
USA ALASKA 1907
USA HAWAII 1808
USA TOLLFREE ACCESS 1800
USA TOLLFREE ACCESS 1844
USA TOLLFREE ACCESS 1855
USA TOLLFREE ACCESS 1866
USA TOLLFREE ACCESS 1877
USA TOLLFREE ACCESS 1880
USA TOLLFREE ACCESS 1881
USA TOLLFREE ACCESS 1882
USA TOLLFREE ACCESS 1888
UZBEKISTAN 998
VANUATU 678
VATICAN CITY 379
VENEZUELA 58
VENEZUELA CARACAS 58212
VENEZUELA MOBILE 584
VIETNAM 84
VIETNAM MOBILE 8490
VIETNAM MOBILE 8491
VIETNAM MOBILE 8495
WALLIS AND FUTUNA 681
YEMEN 967
ZAMBIA 260
ZAMBIA MOBILE 2609
ZAMBIA MOBILE - MTN 26096
ZAMBIA MOBILE - ZAIN 26097
ZAMBIA MOBILE - ZAMTEL 26094
ZAMBIA MOBILE - ZAMTEL 26095
ZIMBABWE 263
ZIMBABWE MOBILE - ECONET 26377
ZIMBABWE MOBILE - ECONET 26378
ZIMBABWE MOBILE - NETONE 26371
ZIMBABWE MOBILE - TELECEL 26373
ZIMBABWE VOIP 26386
ZIMBABWE VOIP - LIQUID 2638677

In Sheet 2, I have one column with country codes : eg :

USA 1
ZIMBABWE 263
WALLIS AND FUTUNA 681
YEMEN 967
ZAMBIA 260
VIETNAM 84


How can I split the dialling code in Sheet 1 in to country code and area code, by somehow matching the country code from sheet 2 to the left side of column 2 in sheet 1. Please bear in mind that the country code can be between 1 and 3 digits.

Assistance would be highly appreciated.

br

Stefan