Results 1 to 4 of 4

Have cell text fill portion of static hyperlink

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2011
    Location
    Carrboro, NC
    MS-Off Ver
    Excel 2010
    Posts
    32

    Exclamation 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!
    Last edited by NBVC; 06-13-2011 at 07:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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