Novice at this...

The URL list is in column B.

When I put
=HYPERLINK(A1,A1)

in B1, it changes the the URL that was displayed to a 0

"Gary''s Student" wrote:

In B1:

=HYPERLINK(A1,A1) and copy down
--
Gary''s Student - gsnu200829


"jabe813" wrote:

I have sheet that contains a column of URLs that are NOT linked.

Is there a way I can automate the process and make every URL in the column a
link in the sheet?