"rdenny1900" wrote
in message ...

Wow, what a quick reply......and thank you!!

Fast! It took Max 1 and a half hours <vbg

Theres a couple of problems. First is that I need it to say:

<a href="http://ABORTIONLA.WS" target="_blank" title="ABORTION
LAWS"ABORTIONLA.WS </a<br

So pretty much its missing the quotation marks. Thats not the big
issue because I can fix that stuff later with replace command.

="<a href=http://"""&A1&""" target="&"_ "&" title="""&B1&""""&A1&"</a<br"

The big issue is that when I paste the formula in column 3 after the
first line, (example: Line 2, Line 3, Line 4, etc...) it keeps giving
me the values from LINE 1 (column 1 and 2). I see that the variables
A1 and B1 keep getting used but I guess I need the values from each
individual line to corrospond to that line. Like for line two I guess
the variables need to say A2 and B2. I am not sure how to do that tho
and typing in the new values in the formula are just not feasable. I
am sure I am just doing something stupid because I have never used this
program before, but cant get it to work.

If you put it into C1 say, then copy and paste into C2 and you should see it
update automatically. I do