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?
Bookmarks