Hyperlink Question?

[Jason]

Hi

I have a table (column) with about 1000 website urls. They aren't
linked, just static text -- how can I enmass make those all clickable
hyperlinks ?

I dread having to re-enter or copy and paste that many with the
=HYPERLINK() method.

Thanks,
Jason

 

[Frank Kabel]

Hi
see:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

in the middle of this page is some code to convert text to hyperlinks