2009-03-01, 01:48 PM
|
#4
|
If there is nobody out there, that's a lot of real estate going to waste!
Join Date: Dec 2003
Posts: 2,177
|
Quote:
Originally Posted by Greenie
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
|
|
|