Greenguy's Board - View Single Post - a way to batch automate url list to add href tags

Greenguy · 2009-02-25, 04:59 PM

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.

2009-02-25, 04:59 PM	#2
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	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. __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network