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.
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