 |
|
|
|
|
|
|
|
|
2005-10-07, 11:43 PM
|
#1 |
|
You can now put whatever you want in this space :)
Join Date: Sep 2005
Posts: 525
 |
Making Links & Descriptions w/Excel
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. |
|
|
|
2005-10-08, 12:41 PM
|
#2 |
|
Operator! Give me the number for 911!
Join Date: Sep 2005
Location: Colorado Springs
Posts: 134
 |
THAT'LL COST YOU $200!
=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
__________________
Please Re-Read The Rules For Sig Files |
|
|
|
|
2005-10-11, 03:18 AM
|
#3 |
|
You can now put whatever you want in this space :)
Join Date: Sep 2005
Posts: 525
|
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.
|
|
|
|
 |
|
|
Linear Mode
