+ Reply to Thread
Results 1 to 6 of 6

Looking up city names form cells containing addresses

  1. #1
    Registered User
    Join Date
    06-27-2022
    Location
    south africa
    MS-Off Ver
    365
    Posts
    3

    Looking up city names form cells containing addresses

    Hi. May you assist with populating city names from cells containing addresses

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,810

    Re: Looking up city names form cells containing addresses

    Hi there.

    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



  3. #3
    Registered User
    Join Date
    06-27-2022
    Location
    south africa
    MS-Off Ver
    365
    Posts
    3

    Re: Looking up city names form cells containing addresses

    Hi,

    I have attached a sample of the excel sheet for your review.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,810

    Re: Looking up city names form cells containing addresses

    Where are the expected answers? (Re-read the yellow banner, please).

  5. #5
    Registered User
    Join Date
    06-27-2022
    Location
    south africa
    MS-Off Ver
    365
    Posts
    3

    Re: Looking up city names form cells containing addresses

    Hi Kennedy,

    My apologies. I am looking to find the city names only from the addresses given in the spreadsheet. Furthermore is there an API or online resource that can do the same task?

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,810

    Re: Looking up city names form cells containing addresses

    I have no idea what you want. I asked for expected answers to be given. You have not done so. I suspect that there is no logic, that Excel can exploit, behind this request and so, it can not be done.

    I shall step back at this point.

    Good luck.

+ 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. [SOLVED] Lookup city names in a string and then return the city code from a table
    By Babbabooie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2021, 03:24 PM
  2. Replies: 8
    Last Post: 10-16-2017, 03:08 AM
  3. [SOLVED] Separating City Name From Addresses Without Delimiter
    By probuddha in forum Excel General
    Replies: 5
    Last Post: 10-11-2017, 01:23 PM
  4. Replies: 3
    Last Post: 02-07-2016, 03:58 AM
  5. Replies: 3
    Last Post: 08-19-2014, 10:24 AM
  6. Replies: 4
    Last Post: 04-16-2014, 04:59 PM
  7. Replies: 2
    Last Post: 06-19-2012, 11:30 AM

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