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?
Thank you all - I found it: =HYPERLINK(link_location,friendly_name)