Why can I not manage to merge these two formula - brain block central!

[Upex]

Hi All,

Hope you're well and safe.

Having another mental meltdown and wonder if anyone can steer me right please?

I have a start address in E1, end address in F1

In M1 I have:
=CONCATENATE("Google Maps",SUBSTITUTE(E1," ","+"),"&daddr=",SUBSTITUTE(F1," ","+"))

in M2 I have
=HYPERLINK(M1)

Which works. I click it and get the maps pop up for the two destinations. However, I can't seem to get this to function in one cell, i.e. M1 being:

=HYPERLINK(CONCATENATE("Google Maps",SUBSTITUTE(E1," ","+"),"&daddr=",SUBSTITUTE(F1," ","+")))

Just get an error pop up to say cannot open the specified file?

Cheers in advance everyone

 

[Upex]

Just in case it helps, the "Google maps" elements above are actually the web address:

h t t p :/ /maps.go ogle.co.uk/ maps?f= d&source=s_ d&saddr=

without the spaces of course- it linked them when posting

 

[KRice]

try...

=HYPERLINK(CONCATENATE("https://www.google.com/maps?saddr=",SUBSTITUTE(E1," ","+"),"&daddr=",SUBSTITUTE(F1," ","+")))

 

[Upex]

Many thanks Kirk, that works!

However, I can't see the difference between what I had tried (posted above) and what you supplied. Really must be having a blind/bad day - what did you do differently? Only thing just spotted was the HTTPS - is that what did it?

 

[KRice]

I spelled out the entire URL beginning with https and also included the starting address field name (saddr=). I'm glad you got it working.