+ Reply to Thread
Results 1 to 6 of 6

How to insert telephone country code using ISO code

Hybrid View

  1. #1
    Registered User
    Join Date
    06-20-2022
    Location
    Doha,Qatar
    MS-Off Ver
    2019
    Posts
    74

    How to insert telephone country code using ISO code

    Data format - 12345678/QA
    Required format - +974-12345678

    Thanks

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,260

    Re: How to replace county code

    Hi there. I suspect your question has been hugely oversimplified.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,765

    Re: How to replace county code

    First you need a list that gives all the country ISO codes (like QA) and the corresponding telephone country code (974).

    Once you have that the Excel part is not hard.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    08-22-2022
    Location
    United States
    MS-Off Ver
    Microsoft 365
    Posts
    28

    Re: How to insert telephone country code using ISO code

    I got the country iso by the code from this answer: TelephonyManager tm = (TelephonyManager)getSystemService(Context. TELEPHONY_SERVICE); String countryCode = tm.

    Regards,
    James

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,765

    Re: How to insert telephone country code using ISO code

    Quote Originally Posted by Jameswalter View Post
    I got the country iso by the code from this answer: TelephonyManager tm = (TelephonyManager)getSystemService(Context. TELEPHONY_SERVICE); String countryCode = tm.
    Sorry, this means nothing to me out of context. What is this? How do you use it in Excel?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,598

    Re: How to insert telephone country code using ISO code

    Jeff - the member to whom you have responded has posted 8 other similarly vague and frankly useless posts. I think they are simply post building. They have not responded to a PM I sent them earlier today.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 2 letter country code within a string to full country name?
    By berserk539 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2021, 11:17 AM
  2. Add name with country code
    By dibyendu2280 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2019, 12:39 AM
  3. How to convert countries into country code
    By vivmishra in forum Excel General
    Replies: 3
    Last Post: 12-21-2016, 07:10 AM
  4. GPS coordinates based on ZIP code & country
    By snb in forum Tips and Tutorials
    Replies: 0
    Last Post: 01-06-2011, 11:37 AM
  5. Find a country against code
    By tqm1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2007, 05:33 AM
  6. Replies: 1
    Last Post: 01-27-2005, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1