Hyperlinking a Mileage Calculator

[HowlingWulf]

Good Morning,

I am trying to hyperlink to google maps but in doing so I am also trying to substitute two values (postcodes) on my spreadsheet into the address from and the address to.
For example:

=HYPERLINK("https://maps.google.co.uk/maps?saddr="&SUBSTITUTE(C8," ",1)&"&daddr="&SUBSTITUTE(C10," ",1))

I have tried various iterations of this but to no avail. It keeps telling me it 'cannot open the specified file'.

Please can anyone help? It's driving me nuts (pun intended).

Huge thanks in advance.

Wulf

 

[AlanY]

try this

=HYPERLINK("https://maps.google.co.uk/maps/dir/"&C8&"/"&C10)

 

[HowlingWulf]

Many thanks AlanY, that works brilliantly.

Do you know a way I can get that to work as a button or as a different piece of text rather than a URL, i.e: 'Calculate Distance'?

Cheers

 

[HowlingWulf]

Not to worry, I figured it out. Was reasonably simple I just couldn't see it for looking. Much obliged. Have a nice day.

 

[AlanY]

you're welcome