Hi
see:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
(in the middle of this page)

--
Regards
Frank Kabel
Frankfurt, Germany
"philmah" schrieb im Newsbeitrag
...
I have a spreadsheet with '000's of rows - the first column is text which
in
fact is a URL - how do I convert them all into URL's without going through
them individually and double clicking each one?

PS this is urgent :-