Help with inserting a link to google maps from cells in a spreadsheet

[handhglassworks]

Hello. I need help inserting a link to google maps that also uses certain cells to automatically open a map with the address inserted in the cells.
Here's my goal:
CELL E3 (house number and street name)
+
CELL E4 (city and zip code)

I want to input those and then have a button or link in CELL B50 that I can press that will send me to Google Maps and automatically have the address inserted so that I don't have to retype it. I can just check to see if it's right and then print it.

Please help. I appreciate everyone who helps with this website.

Thanks.

Greg

[daffodil11]

Hello and welcome to the forums!

This was a lot of fun to research:

=HYPERLINK("https://maps.google.com/maps?q="&SUBSTITUTE(E3," ","%20",99)&"%20"&SUBSTITUTE(E4," ","%20",2)&"&rls=com.microsoft:en-us:IE-SearchBox&oe=&um=1&ie=UTF-8&hl=en&sa=N&tab=wl")

[handhglassworks]

daffodil11,

You're awesome and your help is greatly appreciated. Whenever I inserted your formula into my cell, it looks like:Screen shot 2013-10-21 at 1.12.55 PM.png

Is there a way to clean it up so that it looks nicer? Like a button or something? I hope my question doesn't leave you feeling like I'm not appreciative, because I'll be doing it the way you showed even if there's no way to clean it up because it makes my job A LOT easier.

[handhglassworks]

Actually, when it links to Google Maps it includes 20% in the address and confuses it a little. Is there a way for me to include my actual EXCEL DOCUMENT with one of these posts? I tried to upload it by the image attacher, but it won't work since it's an image. Please know that I'm pretty much an idiot. Thanks.

[handhglassworks]

I GOT IT TO WORK!!!!! daffodil11, thanks for your help. I appreciate you and don't even know you.

[daffodil11]

Haha. The %20 was intentional. The formula was substituting each space between words and numbers with %20 because thats what the actual hyperlink looks like. You can clean up links by putting a comma at the end, followed by the friendly version like =HYPERLINK("http://www.smbc-comics.com","SMBC") will show up as just SMBC.


In your screenshot it looks like the space between the house and road was another character instead of a regular space.

In the end, I'm glad it worked out. New problems mean new solutions, and I'm always game for learning.

[JayFactory]

Sorry to start in an old thread but I have a similar request, this is to be put into a Google Spreadsheet by the way

in cell B4 I have either one of three letter combinations : AP or CT or WH

Where AP is located at 1/47 Princess Highway, Albion Park Rail, 2527
Where CT is located at 61 Blaxland Road, Campbelltown, 2560
Where WH is located at 17 Airds Road, Minto, 2566

In cell D4 there is an address without a postcode or suburb (eg. 203 High Street)
In cell E4 there is a suburb only (eg Penrith)

All locations are in New South Wales, Australia

I would like to be able to click on a link that will give me the directions from AP, WH, and CT to whatever address I put in, can someone help me ? I have been trying to figure it out for weeks and I cannot seem to do it.

Please!

[JayFactory]

PS Not an excel sheet to be uploaded to Google Drive but an actual Google spreadsheet

[daffodil11]

Start a new thread, and someone will jump on it.

It's better than incurring the wrath of the Excel gods. For best results, always start a post with an attached example of your work. If your work is sensitive, make it unsensitive or create something analagous. Don't attach pictures. You can attach files by going to Go Advanced at the bottom, scroll down in the next page to Manage Attachments, browse to the file, Upload it, and then hit Done, and Submit Reply.