Thread: Have cell text fill portion of static hyperlink

I'd like to have excel create a link to a fixed google map based on text from another cell. Here's a link I found to provide a static google map of any location:

http://maps.google.com/maps/api/stat...p&sensor=false

That link will produce a static map of Boston, MA. But I can't get Excel to fill that small portion of the link that specifies location with whatever I type in a different cell.

Example: In cell A1, I have "Boston, MA". In cell A2, I would like to have excel replace a portion of a fixed link with the text from A1.

http://maps.google.com/maps/api/staticmap?center=THIS PART HERE SHOULD FILL WITH THE ADDRESS FROM CELL A1&zoom=15&size=512x512&maptype=roadmap&sensor=false

But whenever I type:

=HYPERLINK("http://maps.google.com/maps/api/staticmap?center=A1&zoom=15&size=512x512&maptype=roadmap&sensor=false";"map"),

The map produced actually uses the text A1, rather than the text from the cell A1.

How do I get it to populate the text from the cell into that portion of the link?

Thanks!

Try:

=HYPERLINK("http://maps.google.com/maps/api/staticmap?center="&A1&"&zoom=15&size=512x512&maptype=roadmap&sensor=false";"map")

I am not sure, though if you should have a ; or , to separate link_location from friendly_name in formula... seeing as you are in North Carolina?

.. if above doesn't work, try:

=HYPERLINK("http://maps.google.com/maps/api/staticmap?center="&A1&"&zoom=15&size=512x512&maptype=roadmap&sensor=false","map")

You can make this more helpful:

=HYPERLINK("http://maps.google.com/maps/api/staticmap?center="&A1&"&zoom=15&size=512x512&maptype=roadmap&sensor=false","Map of " & A1)

Which will then display "Map of Boston, MA" rather than just "map"

Regards