Convert list of URLs to Hyperlinks

J

jabe813

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?
 
J

jabe813

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
 
J

jabe813

Thank you. I tried that as well.

Instead of displaying a 0 it displays "Address"
Links to the right place but, I need to display the URL

I am supposed to be putting this in the formula bar, correct?
 
Top