software

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 www.potato.blogspot.com

Any ideas?

JH--
Jetheat
------------------------------------------------------------------------
Jetheat's Profile: www.excelforum.com/member.php...oamp;userid=10073
View this thread: www.excelforum.com/showthread...hreadid=519149Hi

You can try this

=HYPERLINK(quot;www.quot; amp; A1 amp;quot;.blogspot.com/quot;)

--
Regards Ron de Bruin
www.rondebruin.nlquot;Jetheatquot; gt; wrote in message
...
gt;
gt; If I have the word potato in cell A1 and in cell A2, I have a web
gt; address, how do I insert the word from A1 into the middle of the web
gt; address in A2?
gt;
gt; The Web address should end up like www.potato.blogspot.com
gt;
gt; Any ideas?
gt;
gt; JH
gt;
gt;
gt; --
gt; Jetheat
gt; ------------------------------------------------------------------------
gt; Jetheat's Profile: www.excelforum.com/member.php...oamp;userid=10073
gt; View this thread: www.excelforum.com/showthread...hreadid=519149
gt;

Works great, thank you very much--
Jetheat
------------------------------------------------------------------------
Jetheat's Profile: www.excelforum.com/member.php...oamp;userid=10073
View this thread: www.excelforum.com/showthread...hreadid=519149