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.
10 Replies
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.
Perhaps not in one go, but you can us the HYPERLINK function. Enter it in the first cell and copy it down.
Thank you, Riny_van_Eekelen. To clarify, are saying the "drag" function could work, even if each cell contains a unique URL?
SpikeK Jus try. Perhaps I don't know what you mean.
