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" <(E-Mail Removed)> schrieb im Newsbeitrag
news:99646280-552B-48D6-9743-(E-Mail Removed)...
>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