how do I easily convert a single column of text (multiple rows si.

P

philmah

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

Dave Peterson

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.
 
Top