Not sure, but see whether this helps a bit ..
(we're just concatenating the bits together)

Put in C1:
="<a href=http://"&A1&" target="&"_ "&" title="&B1&""&A1&"</a<br"
Copy down

If col C returns what you want, then you could freeze the values in the col
via
an in-place copy paste special values ok
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"rdenny1900" wrote
in message ...

Hi there. Brand new to the board and I am trying to find the answer to a
question. I need some serious help here from a total beginner to excel.
I have never used functions.

I have a list of 500 domain names that are listed in the first column
in excel. In the second column I have more text. In the Third column I
am trying to have the text of the first and second column inserted into
a phrase in the second column. Example:

Lets say this is in column 1:
COLUMN1TEXT

This is in Column 2:
COLUMN2TEXT

This is what I want in column 3:
<a href="http://COLUMN1TEXT" target="_blank"
title="COLUMN2TEXT"COLUMN1TEXT</a<br

Does anyone know how in the world to do this? Do I need to create a
function to do this? I would really appreciate any help anyone can give
me!! Thanks, Ron


--
rdenny1900


------------------------------------------------------------------------
rdenny1900's Profile:
http://www.excelforum.com/member.php...o&userid=24435
View this thread: http://www.excelforum.com/showthread...hreadid=380372