Greenguy's Board - View Single Post - a way to batch automate url list to add href tags

Chffr · 2009-02-25, 09:52 PM

oops...

scratch that...

I meant to say:

place formula =A1&""&B1&""&C1&""&D1&""&E1 into cell F1

A1=<a href="
B1=URL
C1=">
D1=Description text
E1=</a>
F1=Hyperlinked descriptive text

I'm having to save the URL's into a notepad doc then import them from file (delimited, separated by space into first cell). I do the same with the description text.

That should make more sense...and work.

2009-02-25, 09:52 PM	#4
Chffr A woman is like beer. They look good, they smell good, and you'd step over your own mother just to get one! Join Date: Feb 2009 Location: NYC Posts: 57	oops... scratch that... I meant to say: place formula =A1&""&B1&""&C1&""&D1&""&E1 into cell F1 A1=<a href=" B1=URL C1="> D1=Description text E1=</a> F1=Hyperlinked descriptive text I'm having to save the URL's into a notepad doc then import them from file (delimited, separated by space into first cell). I do the same with the description text. That should make more sense...and work. __________________ Submit to CHuFFeRsLiST