How to ignore displayed text to extract from underlying function

Hello,

I am trying to extract the link from the following:

=HYPERLINK("linkgoeshere","CLICK "&B62)

So clearly the actual displayed text is "CLICK" + the string in B62, which has nothing to do with the link. I think the following would work to extract the link "=MID(J62,13,(FIND("CLICK",J62)-16))", where all the links are in J column (apologies I can't share the actual file because of confidential information, additonally I can't even include an actual link here because I am a new member). But it became clear to me that any formula I use to extract sub-strings analyzes just the displayed text or label. I can't figure out how to instead extract from the underlying formula/text. I guess the underlying formula is not really treated like a string as I tried to do. Any ideas on how extract the hyperlink?

Thank you

I was using sheets so =FORMULATEXT() worked! I tried to google multiple times using different prompts to find this formula but I didn't find any mention of it. I wish I knew a way to search the excel formula directory

Done! I was wondering how to, thanks!