Forum Discussion
Convert Column Of URLs To Hyperlinks
Anyone aware of a function/formula to convert a column of URLs to hyperlinks in one move? MY column contains 813 URLs.
You may have to upload a sample workbook to show how HYPERLINK is not working for you.
Riny_van_Eekelen 's solution is the best approach. The fill handle has to be used because spilling hyperlinks will invalidate the links.
Sure thing, Patrick2788. The Hyperlink function works if performed one cell at a time.
What I'm hoping to do is convert a column of 812 URLs to hyperlinks in one move (formula, etc.).
Here's a small sample of that data. "Friendly Names" are in Column A; 812 URLs are in Column B:
I know this is real late, but I just got one working then copied the format to the rest of the cells. I had over 500 and it worked. (Excel 365)
- I had just copied a link into cell a1.
- Clicked into the formula bar.
- Hit Ctrl+a, so it selected the text.
- Hit Enter.
- The text is now a hyperlink.
- Right click on a1
- Select Format Painter, (Paint brush icon)
- Then select the cells you want to act the same.
- You could table your range and then use HYPERLINK. The formula will fill on its own to the bottom of the table.
- That was my initial thought. However, I didn't find that option in MS guidance or other sites. Will give it a try. Thx.
