PDA

View Full Version : Making Links & Descriptions w/Excel


DJilla
2005-10-08, 12:43 AM
I was hoping to get some advice about what you find is the easiest way/program to use for making links, descriptions and code combinations for your bulk LL's, etc.

Do you use Excel, Access, some other proprietary program.

Might anyone have a template they've made for Excel/Access that they can offer me for free or nominal charge?

Thanks for the best advice around.

cybersexhound
2005-10-08, 01:41 PM
=CONCATENATE("<a href=",C1,">",A1,"</a><br>",B1)

C1=URL
A1=TITLE
B1=DESCRIPTION

Cant use " in the href as excel will take it as apart of the formula if you need to do an image it will look something like this:

=CONCATENATE("<a href=",B1,">","<img src=",C1,">")
B1 = URL
C1= IMG PATH

DJilla
2005-10-11, 04:18 AM
Thanks! Uh duh! I am not really an Excel guy anymore and its been years and years since making anything but the most basic of quick sheets. I would have spent hours and hours before I remembered or figured out that Excel eats the quotes and that's why it wasn't working. Thanks again! Simple enough.