Closed Thread
Results 1 to 2 of 2

Automatically finding latitudes and longitudes from street addresses and zips

  1. #1
    Forum Contributor
    Join Date
    01-28-2008
    MS-Off Ver
    Excel 365
    Posts
    160

    Automatically finding latitudes and longitudes from street addresses and zips

    Thank you in advance for looking at this.

    I have a list of street addresses and zip codes in column A.

    The following hyperlink prompts for a street address and zip, and then displays the latitude and longitude:
    http://www.latlong.net/convert-address-to-lat-long.html

    For example, if you enter the street address and zip:
    401 21st Ave S., 37203

    the site tells you the latitude and longitude are 36.04 and -86.76.

    Is there anyway I can use the HYPERLINK (or other) worksheet in columns B and C to automatically fill in the latitudes and longitudes of the address is in column A?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2506 Win 11
    Posts
    24,901

    Re: Automatically finding latitudes and longitudes from street addresses and zips

    This is a duplicate posting of a thread in the commercial services. I will close this thread and you may continue in the Commercial Services.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Get latitudes and longitudes from street address and zip
    By Larry.LeBlanc@O in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2017, 07:06 PM
  2. Replies: 3
    Last Post: 02-12-2013, 10:16 AM
  3. Breaking apart street addresses
    By abuchan in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-16-2010, 10:36 PM
  4. Sorting street addresses
    By Marta in forum Excel General
    Replies: 5
    Last Post: 07-17-2006, 08:35 PM
  5. FInding Duplacates & correcting addresses automatically
    By TiffanyD. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-06-2006, 12:20 PM
  6. Help! How to sort addresses by street then by #......
    By HelpingOthersTD in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-15-2006, 04:35 AM
  7. Convert latitudes and longitudes to decimal
    By Demi in forum Excel General
    Replies: 7
    Last Post: 03-29-2006, 04:50 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