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.
13 Replies
For Mac users the simplest solution for converting a list of text URL's to hyperlinks is to import the entire table into Numbers. Numbers recognizes the https:// text and automatically converts it to a url. This is functionality that is virtually ubiquitous in contemporary software but IS NOT a part of the Excel portfolio (yet).
Copy the URL cell. Select the column. Then Past Special -> Formats only.
This worked great!
Implied but not said outright is that before copying the URL cell, you should first click into cell text and hit enter key. This converts a single cell to clickable URL.
So the 4-step process which works for any block of URL cells:
1) Hit Enter in first URL cell to make clickable
2) Then copy the linked URL cell
3) Select row/column/range of cells containing URLs you wish to format as clickable.
4) Paste Special>Formatting
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.
