Closed Thread
Results 1 to 2 of 2

Get latitudes and longitudes from street address and zip

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

    Get latitudes and longitudes from street address and zip

    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, at that site 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 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: Get latitudes and longitudes from street address and zip

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    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. Look up specific street address within street address range
    By dbd6lsx in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-11-2015, 09:46 PM
  2. Pulling company name, street address, city, state, and zip from address
    By UNREAL2K4 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-13-2015, 12:53 PM
  3. Need to pull street address out of full address in a cell
    By Philalawyer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2014, 09:48 AM
  4. separate street address and street number
    By iwanttoplaywii in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-24-2011, 09:45 PM
  5. Street Address Help
    By zero760 in forum Excel General
    Replies: 1
    Last Post: 12-01-2008, 09:23 PM
  6. how do you sort by street name in address?
    By old hickory in forum Excel General
    Replies: 4
    Last Post: 08-04-2007, 12:46 AM
  7. [SOLVED] 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