Simple excel url creation formula

robjf · 21 Jun 2008 at 00:38

Evening guys.

Ive got a load (about 30 - 40) coordinates which i would like to use in excel to generate google maps urls. I have 3 cells (side by side) 2 with coordinates and the third with the name of the coordinate.

Eg:
51.913853 -2.073365 Location 1

Using an excel formula, how can i create the url for google maps. Here is how the url should look for the above:

Code:

http://maps.google.com/maps?q=51.913853,+-2.073365+(Home)&iwloc=A&hl=en

Thanks for any advice

Rob

BigglesPiP · 21 Jun 2008 at 00:43

Code:

=("http://maps.google.com/maps?q="&A1&",+"&A2&"+(Home)&iwloc=A&hl=en")

robjf · 21 Jun 2008 at 01:01

Thankyou

Is there anyway to turn that into a hyperlink, currently its only a text link and if you click the cell all you can copy is the formula.

BigglesPiP · 21 Jun 2008 at 01:08

Cell attributes I think.

robjf · 21 Jun 2008 at 02:34

Ahh i got it eventually!

Code:

=HYPERLINK("http://maps.google.com/maps?q="&A1&",+"&A2&"+(Home)&iwloc=A&hl=en")

That did the trick! Cheers Biggles!