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

Chffr · 2009-02-25, 08:13 PM

Excell - lent!!!

Thanks Green Guy!

I used the =A1&""&B1&""&C1&""&D1&""&F1 formula. I included two more cells D1 & F1. I'll define it here in case anybody else needs the info.

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

2009-02-25, 08:13 PM	#3
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	Excell - lent!!! Thanks Green Guy! I used the =A1&""&B1&""&C1&""&D1&""&F1 formula. I included two more cells D1 & F1. I'll define it here in case anybody else needs the info. A1=<a href=" B1=URL C1="> D1=Description text F1=</a> __________________ Submit to CHuFFeRsLiST