Nov 11 2022 08:01 AM
Anyone aware of a function/formula to convert a column of URLs to hyperlinks in one move? MY column contains 813 URLs.
Nov 11 2022 09:04 AM
Perhaps not in one go, but you can us the HYPERLINK function. Enter it in the first cell and copy it down.
Nov 11 2022 10:00 AM
Thank you, @Riny_van_Eekelen. To clarify, are saying the "drag" function could work, even if each cell contains a unique URL?
Nov 11 2022 10:26 AM
@SpikeK Jus try. Perhaps I don't know what you mean.
Nov 17 2022 08:08 AM
Nov 17 2022 08:26 AM
You may have to upload a sample workbook to show how HYPERLINK is not working for you.
@Riny_van_Eekelen 's solution is the best approach. The fill handle has to be used because spilling hyperlinks will invalidate the links.
Nov 17 2022 09:05 AM
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:
Nov 17 2022 09:26 AM
Nov 17 2022 09:35 AM