Greenguy's Board

Greenguy's Board (http://www.greenguysboard.com/board/index.php)
-   Programming & Scripting (http://www.greenguysboard.com/board/forumdisplay.php?f=15)
-   -   Making Links & Descriptions w/Excel (http://www.greenguysboard.com/board/showthread.php?t=24811)

DJilla 2005-10-07 11:43 PM

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.

cybersexhound 2005-10-08 12:41 PM

THAT'LL COST YOU $200!
 
=CONCATENATE("",A1,"
",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("","")
B1 = URL
C1= IMG PATH

DJilla 2005-10-11 03: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.


All times are GMT -4. The time now is 08:52 PM.

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