Insert Cell Contents in middle of web address

[Jetheat]

If I have the word potato in cell A1 and in cell A2, I have a web
address, how do I insert the word from A1 into the middle of the web
address in A2?

The Web address should end up like http://www.potato.blogspot.com

Any ideas?

JH

 

[Ron de Bruin]

Hi

You can try this

=HYPERLINK("http://www." & A1 &".blogspot.com/")

 

[Jetheat]

Works great, thank you very much