Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |