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.
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.
- Thanks for the suggestion. However, this was a no-go. No indication of "one-shot hyperlinking" capabilities/formulas in official Excel documents. Appreciate it.
