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 :-

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 :-

I'd insert a new column A and do:

=hyperlink(b1)
(in A1 and drag down)

Or maybe:
=hyperlink("http://" & b1)
and drag down.

depends on what you really have in that cell.


philmah wrote:

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 :-

--

Dave Peterson