title: How to extract URL from link (link feature, not HYPERLINK formula) in Google Sheets?
body: <p>Google Sheets allows to specify (hyper)links in two ways:</p>
  <ul>
  <li>By using <a href="https://support.google.com/docs/answer/3093313?hl=en" rel="nofollow noreferrer">HYPERLINK formula/function</a>, e.g. <code>=HYPERLINK(&quot;http://example.com/&quot;, &quot;Example.com&quot;)</code></li>
  <li>By using <a href="https://support.google.com/docs/answer/45893?hl=en" rel="nofollow noreferrer">&quot;linking&quot; feature</a> – <code>Insert » Insert Link</code></li>
  </ul>
  <p>There are a lot of solutions around the web, and StackOverflow, for extracting URL from the first option - the HYPERLINK formula, but <strong>I haven't found any way how to extract it from the second option.</strong></p>
  <p><a href="https://i.stack.imgur.com/1iql8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1iql8.png" alt="screenshot" /></a></p>
  <p><a href="https://docs.google.com/spreadsheets/d/1RNn4iVDgROwtYTqYdUhvgxdbF1WItb9rs5j203DhDpA/edit" rel="nofollow noreferrer">Example Sheet</a></p>