Convert list of URLs to Hyperlinks

  • Thread starter Thread starter jabe813
  • Start date Start date
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?
 
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
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

URL/HYPERLINK 3
How to Convert EML to PST in 2025? 0
hyperlink 6
hyperlinks within Excel 3
Ruined hyperlinks... 1
Hyperlinks 3
Change links to hyperlinks in a workbook? 6
Excel hyperlink within workbook and SharePoint drafts 2

Back
Top