Microsoft Excel - concatenate and create a weblink

Asked By pete r. on 08-Apr-14 06:27 PM
Hello

I have created a formula like this =CONCATENATE("https://maps.google.com/maps?q=",A1,"+",B1,"+",C1) which for example produces this  https://maps.google.com/maps?q=5 London Road+London+SW8 9JA
What do I need to add to this formula to make it present this as a hyperlink in the cell.  Do I need to make it an array forumla...

Be glad of help.
Thanks

Peter
Harry Boughen replied to pete r. on 08-Apr-14 09:10 PM
Hello pete,
You could use
= HYPERLINK(yourfolmularesult, suitablenametoappearincell)

I am not sure whether you can use a formula result if you go Insert/Hyperlink
Regards
Harry