Creating links in excel in a batch

%3CLINGO-SUB%20id%3D%22lingo-sub-1604384%22%20slang%3D%22en-US%22%3ECreating%20links%20in%20excel%20in%20a%20batch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604384%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20in%20an%20Excel%20page%20two%20columns%3A%20One%20is%20the%20display%20text%20and%20the%20other%20has%20a%20URL%3C%2FP%3E%3CP%3EI%20would%20like%20to%20create%20a%20hot%20link%20in%20the%20first%20column%2C%20based%20on%20the%20URL%20in%20the%20second.%3C%2FP%3E%3CP%3EI%20have%20over%207000%20rows.%20I%20can%20the%20linking%20one%20at%20a%20time.%20Is%20there%20a%20formula%20that%20lets%20me%20do%20the%207000%2B%20rows%20in%20one%20click%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1604384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604915%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20links%20in%20excel%20in%20a%20batch%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604915%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767248%22%20target%3D%22_blank%22%3E%40JGalron%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20all%20-%20I%20found%20it%3A%20%3DHYPERLINK%3CSPAN%3E(%3C%2FSPAN%3E%3CSTRONG%3Elink_location%3C%2FSTRONG%3E%3CSPAN%3E%2Cfriendly_name)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

1 Reply
Highlighted

@JGalron 

Thank you all - I found it: =HYPERLINK(link_location,friendly_name)