+ Reply to Thread
Results 1 to 3 of 3

Pull country names from address

  1. #1
    Registered User
    Join Date
    06-23-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    2

    Pull country names from address

    Hi,

    Address in my excel spreadsheet is written in below manner with country name being second last word and all the text is separated by comma; is there any way I can separate country names from the address field-
    Facebook HQ,Menlo Park,CA,United States,27717
    Microsoft,Cyber City,DLF Phase III,Gurugram,Haryana,India,122002

    Appreciate all your help on this.

    Thanks,
    Gaurav

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Pull country names from address

    Try this
    Enter formula in B1 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B
    1 Facebook HQ,Menlo Park,CA,United States,27717 United States
    2 Microsoft,Cyber City,DLF Phase III,Gurugram,Haryana,India,122002 India
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    06-23-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    2

    Re: Pull country names from address

    Thanks, this works.....appreciate your help on this.

+ 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. Calculate distance between two address by Google map (in same city and country)
    By ronlau123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2017, 01:09 AM
  2. I need Help to parse address city state zip and country if applicable for all fields
    By danpotash in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2013, 03:16 PM
  3. Country from IP Address
    By bh2 in forum Excel General
    Replies: 2
    Last Post: 02-26-2013, 05:37 PM
  4. Replies: 12
    Last Post: 12-30-2011, 12:52 AM
  5. Replies: 1
    Last Post: 12-22-2011, 09:57 AM
  6. Replies: 1
    Last Post: 12-22-2011, 09:40 AM
  7. Country of Origin pull down to pull over
    By j0k3rk1ll3r in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2011, 12:39 AM

Tags for this Thread

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