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.