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.
Sure thing, Patrick2788. The Hyperlink function works if performed one cell at a time.
What I'm hoping to do is convert a column of 812 URLs to hyperlinks in one move (formula, etc.).
Here's a small sample of that data. "Friendly Names" are in Column A; 812 URLs are in Column B:
You could table your range and then use HYPERLINK. The formula will fill on its own to the bottom of the table.
- That was my initial thought. However, I didn't find that option in MS guidance or other sites. Will give it a try. Thx.