Insert Cell Contents in middle of web address
 

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


--
Jetheat
------------------------------------------------------------------------
Jetheat's Profile: http://www.excelforum.com/member.php...o&userid=10073
View this thread: http://www.excelforum.com/showthread...hreadid=519149

Insert Cell Contents in middle of web address
 

Hi

You can try this

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jetheat" wrote in message
...

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


--
Jetheat
------------------------------------------------------------------------
Jetheat's Profile: http://www.excelforum.com/member.php...o&userid=10073
View this thread: http://www.excelforum.com/showthread...hreadid=519149

Insert Cell Contents in middle of web address
 

Works great, thank you very much


--
Jetheat
------------------------------------------------------------------------
Jetheat's Profile: http://www.excelforum.com/member.php...o&userid=10073
View this thread: http://www.excelforum.com/showthread...hreadid=519149