How can I extract URL from hyperlinks?

[tachyglossus]

I have a worksheet where one column contains hyperlinks (like created with =HYPERLINK(link;text)). How can I create a formula extracting link urls from those hyperlinks? I've tried dozen of search queries and carefully read everything found, but couldn't find a way.

[#2]

@tachyglossus 

Hello,

1. Right-click a hyperlink.
2. From the Context menu, choose Edit Hyperlink. Excel displays the Edit Hyperlink dialog box.
3. Select and copy (Ctrl+C) the entire URL from the Address field of the dialog box.
4. Press Esc to close the Edit Hyperlink dialog box.
5. Paste the URL into any cell desired.

[#3]

@tachyglossus 

Hello, you can follow the steps in the link below

https://howtouseexcel.net/how-to-extract-a-url-from-a-hyperlink-on-excel