Extract URL (Hyperlink) from Text

[MenaXcel]

I have a list of hyperlinks {website addresses} that are embedded in text values {company names} - see attached Excel file.
I want to extract / separate the text overlay from the hyperlink and show the raw URL in a separate Column.

So, instead of this: Google
It would show this: http://www.google.com

How do I extract (separate) the source url {hyperlink}?

Is there a Formula / Function that can do this - like "=geturl"?
The Paste Special Function in Excel doesn't have an menu selection for this specific option
Most of the search results on Google only show the reverse: how to extract a text value from a url

 

[vletm]

MenaXcel
Check this: https://www.contextures.com/excelhyperlinkfunction.html
Extract Hyperlink Address
You can use a macro or a User Defined function (UDF) to extract the address from a hyperlink.