Adding International Calling Codes in front of a phone number

[rohitmadaan]

Hi Everyone,

I need some urgent help with an issue i am having right now. I have an excel file which has a telephone number of a country in column A and Country code in column B. The telephone number in column A is not in one particular order. Some of them have International code with them but others don't have. Can some please help me with adding international calling codes to those numbers which don't have it and ignore those which have it based on the country in column B. A macro for this would be ideal. Thanks in advance.

As far as i understand, the code should read the length of the phone number based on that country and check if it fits in the certain set limit then it should ignore that phone number else add the code in front of the phone number.

Regards

Rohit Madaan

 

[GR00007]

I googled international calling code by country and found there are multiple methods https://en.wikipedia.org/wiki/List_of_international_call_prefixes
Do you have a country table (tab?) with the calling codes you expect?

 

[Fluff]

Cross posted https://www.excelforum.com/excel-ge...s-in-front-of-a-phone-number.html#post5039285

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).