Results 1 to 4 of 4

Thread: Splitting International Dialing codes into country and area code.

  1. #1

    Splitting International Dialing codes into country and area code.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Good day,

    I have the following columns :

    A
    Dailing Codes
    1 93
    2 937
    3 355
    4 35538
    5 35566
    6 213
    7 2135
    8 2136
    9 1684
    .
    .
    .
    .
    .
    .
    ------

    B
    Country Codes
    1 93
    2 355
    3 213
    4 376
    5 244
    6 1
    7 44
    .
    .
    .
    .
    .


    ---------

    Please assist with the following :

    Match the Dialing codes against the country codes from Left to right. if match is found return the country code in column C and the area code in column C. E.G. Dialing code 93(A1) is matched against Array (B1:B210) Country Codes. As 93 is found in the Country Codes array , 93 will be returned as Country Code. Next row : Dialing code 937(A2) is matched against Array (B1:B210) Country Codes. As 93 is found in the Country Codes array , 93 will be returned as Country Code and 7 will be returned as area code. Please refer to attached sample File for sample data.

    Kind regards

    Stefan
    Attached Files Attached Files

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz find attachment.
    Attached Files Attached Files

  3. #3
    Hi,

    Thanks a million. Somehow, if a dialing code starts with 1 e.g 1684 (A26) , the vlookup in the helper column does not find the 1 in the E Column (Country codes). any idea why ?

    br

    Stefan

  4. #4
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please do not cross post without links !

    Read http://www.excelguru.ca/content.php?184 to understand why

    http://www.msofficeforums.com/excel/...ntry-area.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •