Question: how to extract data from hyperlink in excel?
Answer: Right-click a hyperlink. From the Context menu, choose Edit Hyperlink. Excel displays the Edit Hyperlink dialog box. Select and copy (Ctrl+C) the entire URL from the Address field of the dialog box. Press Esc to close the Edit Hyperlink dialog box. Paste the URL into any cell desired.