Broken Formula to Hyperlink longitude and latitude cells to google maps

**Nola ADA** · 05-09-2013, 08:24 AM

I've got a spreadsheet that includes two cells with longitude and latitude. Google maps has a feature that allows you to input the long. and lat. coordinates into a website URL. I want to put these two things together and be able to link to a map displaying the location of the coordinates in the cells. FRUSTRATINGLY, I just can't seem to get it to work...

Here's my basic example of the cells:
L2 M2
LONGITUDE LATITUDE
29.96076 -90.10341

Here's the formula I've got in my Google Maps Hyperlink Cell
=HYPERLINK("http://maps.google.com/maps?q=" &L2 & "," &M2 & ")

The basic Google maps long/lat URL is
http://maps.google.com/maps?q=LONGITUDE,LATITUDE

If the formula above was working properly it should have created:
http://maps.google.com/maps?q=29.96076,-90.10341

Sadly, all this formula does is sit there on my spreadsheet like a bump on a log, it doesn't turn blue and underlined, and it doesn't bring me to google maps. What's wrong with my formula?
Please help!

**Bhuvi** · 05-09-2013, 09:20 AM

Hi Nola,

I can see that you are putting extra spaces in your formula, may be that is why the formula is not getting the correct address.

You can try the below formula, I assume that you have data stating from row 3 with values in col A and col B.
=HYPERLINK("https://maps.google.com/maps?q="&A3&","&B3,"Click to open google maps")

value in cell A3- 29.96076
value in cell B3- -90.10341

you can change the column reference as desired by you.

Regards,
Bhuvanesh

(pls click on the below * if this helps)