Commit a hyperlink created through the =hyperlink formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1072307%22%20slang%3D%22en-US%22%3ERe%3A%20Commit%20a%20hyperlink%20created%20through%20the%20%3Dhyperlink%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F492830%22%20target%3D%22_blank%22%3E%40wilin%3C%2FA%3E%26nbsp%3BI%20should%20clarify%20-%20this%20is%20an%20external%20link%20to%20a%20webpage.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1072297%22%20slang%3D%22en-US%22%3ECommit%20a%20hyperlink%20created%20through%20the%20%3Dhyperlink%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072297%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I've%20created%20a%20hyperlink%20to%20a%20webpage%20in%20a%20cell%20using%20the%20hyperlink%20formula.%3C%2FP%3E%3CP%3Eex.%20%3DHYPERLINK(B40%2CA40)%3C%2FP%3E%3CP%3Ewhere%20column%20B%20is%20the%20link%20and%20column%20A%20is%20the%20friendly%20text%20I%20want%20to%20display.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I'm%20trying%20to%20commit%20the%20formula%2C%20i.e.%20drop%20the%20cell%20references%20and%20copy%20the%20hyperlinked%20text%20to%20cell%20a%20separate%20file.%20None%20of%20the%20special%20paste%20options%20seem%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20you%20have%20suggestions%2C%20including%20some%20other%20way%20to%20mass%20add%20links.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20taking%20the%20time%2C%3C%2FP%3E%3CP%3E%3A)(%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1072297%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-1073020%22%20slang%3D%22en-US%22%3ERe%3A%20Commit%20a%20hyperlink%20created%20through%20the%20%3Dhyperlink%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1073020%22%20slang%3D%22en-US%22%3ESo%20you%20want%20to%20keep%20the%20hyperlink%20working%20but%20not%20reference%20B40%20or%20A40%20anymore%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20only%20option%20i%20could%20find%20was%20to%20paste%20the%20links%20to%20Word%20%2C%20copy%2C%20then%20paste%20back%20to%20Excel%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1074027%22%20slang%3D%22en-US%22%3ERe%3A%20Commit%20a%20hyperlink%20created%20through%20the%20%3Dhyperlink%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1074027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHey%20Wyn%2C%20yeah%20that's%20exactly%20it.%20I%20really%20thought%20I%20was%20overlooking%20something%20simple.%3C%2FP%3E%3CP%3EThanks%20for%20checking%20this%20out.%20Your%20suggestion%20is%20helpful.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I've created a hyperlink to a webpage in a cell using the hyperlink formula.

ex. =HYPERLINK(B40,A40)

where column B is the link and column A is the friendly text I want to display.

 

Now I'm trying to commit the formula, i.e. drop the cell references and copy the hyperlinked text to cell a separate file. None of the special paste options seem to work.

 

Let me know if you have suggestions, including some other way to mass add links.

 

Thanks for taking the time,

(:

2 Replies
So you want to keep the hyperlink working but not reference B40 or A40 anymore?

The only option i could find was to paste the links to Word , copy, then paste back to Excel

@Wyn Hopkins 

 

Hey Wyn, yeah that's exactly it. I really thought I was overlooking something simple.

Thanks for checking this out. Your suggestion is helpful.