View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default 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