Forum Discussion
SpikeK
Nov 11, 2022Copper Contributor
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.
Patrick2788
Nov 17, 2022Silver Contributor
You could table your range and then use HYPERLINK. The formula will fill on its own to the bottom of the table.
SpikeK
Nov 17, 2022Copper Contributor
That was my initial thought. However, I didn't find that option in MS guidance or other sites. Will give it a try. Thx.