Thank you so much! That works. Connie

"Gary''s Student" wrote:

Lets say A1 contains:
http://www.cnn.com

In B1 enter:

=HYPERLINK(A1,A1) and copy down

--
Gary''s Student - gsnu200737


"Connie Martin" wrote:

My spreadsheet of over 10,000 rows has a column with company internet
homepage addresses in it. Is there a way to convert that whole column to
hyperlinks in one shot? Connie