+ 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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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




    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.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    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