a way to batch automate url list to add href tags

[Chffr]

I'm not sure if such a script exist or not but I'm looking for a way to convert a list of 50 or so urls and add <a href=></a>. Free? Not free? Does it exist? Is there a way to do it in Excell?

I can do it by hand but I'd rather not.

[Greenguy]

You can do it in excell

In the 1st column:
<a href="

In the 2nd column the URL

In the 3rd column:
"></a>

In the 4th column you have to put in a formula:
=A1&""&B1&""&C1

The copy 1, 3 & 4 all the way down & 2 would be the list of URL's

OR

Instead of the 4th column, copy 1, 2 & 3 & paste them into a txt pad, then search & replace for a tab.

[Chffr]

Excell - lent!!!

Thanks Green Guy! |bow|

I used the =A1&""&B1&""&C1&""&D1&""&F1 formula. I included two more cells D1 & F1. I'll define it here in case anybody else needs the info.

A1=<a href="
B1=URL
C1=">
D1=Description text
F1=</a>

|bananna||headbang|

[Chffr]

oops...

scratch that...

I meant to say:

place formula =A1&""&B1&""&C1&""&D1&""&E1 into cell F1

A1=<a href="
B1=URL
C1=">
D1=Description text
E1=</a>
F1=Hyperlinked descriptive text

I'm having to save the URL's into a notepad doc then import them from file (delimited, separated by space into first cell). I do the same with the description text.

That should make more sense...and work.

[LD]

If you need to get rid of the formula that strings everything together in the last column and just have the text values, you can copy and paste special, then select "values." Usually not necessary, though.

[Greenguy]

...or just copy that column to a text page & then copy it from there back to the column.

[tickler]

You can do it in excell

In the 1st column:
<a href="

In the 2nd column the URL

In the 3rd column:
"></a>

In the 4th column you have to put in a formula:
=A1&""&B1&""&C1

The copy 1, 3 & 4 all the way down & 2 would be the list of URL's

OR

Instead of the 4th column, copy 1, 2 & 3 & paste them into a txt pad, then search & replace for a tab.
Or in excel use "absolute" references for 1 and 3