I'm trying to come up with a way to add three sections of a web address in order to create a hyperlink out of the concluded result. this might sound a bit odd and i would add a bunch of detail however this form will not yet allow me to until i have posted a few more time.
The idea is to use a web address from google maps, then break it down to add my job site address and then add a pit address and convert this into a hyperlink. (adding a: From: Destination and a To: Destination).
I have been able to accurately add these pieces together however i need to figure out a formula, i order to expedite this process. lots of pits and lots of jobs.
Currently i have been using the ="cell"&"cell" and have been successful adding "words" together, however it seems like excel dose not recognize this as anything more then a function.
I need a way to return the calculated sum back to original text. and then covert this into a hyperlink so i can click and pull up the mapping distance.
Bookmarks