Greenguy's Board


Go Back   Greenguy's Board > Programming & Scripting
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 2005-10-07, 11:43 PM   #1
DJilla
You can now put whatever you want in this space :)
 
DJilla's Avatar
 
Join Date: Sep 2005
Posts: 525
Send a message via ICQ to DJilla
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.
DJilla is offline   Reply With Quote
Old 2005-10-08, 12:41 PM   #2
cybersexhound
Operator! Give me the number for 911!
 
cybersexhound's Avatar
 
Join Date: Sep 2005
Location: Colorado Springs
Posts: 134
Send a message via ICQ to cybersexhound Send a message via Yahoo to cybersexhound
Thumbs up 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
cybersexhound is offline   Reply With Quote
Old 2005-10-11, 03:18 AM   #3
DJilla
You can now put whatever you want in this space :)
 
DJilla's Avatar
 
Join Date: Sep 2005
Posts: 525
Send a message via ICQ to DJilla
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.
DJilla is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 01:27 AM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc