How to extract URL from Link in Google Sheets using a formula?
<p>I have copied from a website a series of hyperlinks and pasted them in a google sheet. The values show up as linked text, not hyperlink formulas, and are still linked correctly. For each row, I'm trying to extract the URL ONLY (not the friendly text) and insert it into the adjacent column. How could this be accomplished using a formula?</p>

<p>For example:</p>

<pre><code>=SOMEFUNCTION(cellThatHoldsLink, returnedURLOnly)
</code></pre>

<p><a href="https://stackoverflow.com/questions/28474308/how-to-get-url-text-out-of-field-with-hyperlink-in-it">This and similar scenarios</a> do not apply because the pasted data are not formulas.
I will accept a script (GAS) solution, or any solution for that matter, but would prefer if it could be done using a formula. I have found dozens of HYPERLINK manipulation scripts, but nothing on this particular scenario, or even how to access the property that is holding that url. Thanks.</p>