Aug 21 2020 11:33 AM
Hi,
I have in an Excel page two columns: One is the display text and the other has a URL
I would like to create a hot link in the first column, based on the URL in the second.
I have over 7000 rows. I can the linking one at a time. Is there a formula that lets me do the 7000+ rows in one click?
Aug 21 2020 04:23 PM
Thank you all - I found it: =HYPERLINK(link_location,friendly_name)