Google Sheets - Extract URL From a Cell Containing a Hyperlink

by Elad Ratson   Last Updated January 13, 2018 23:03 PM

I am using an IFTTT recipe which populates Google Sheets cells with a hyperlink formula like this one:

=HYPERLINK("", "link")

The result in the Google Sheet are cells with the hyperlink, pointing to tweet URLs, like the one below:

| link |

Is there a way to extract ONLY the URL from the hyperlink into another cell using a formula or a combination of formulas without the use of macro code? The desired result is the following:

| link | |

Tags : google-sheets

Related Questions

How to get the data value of NOW() and stored as text

Updated December 22, 2017 17:03 PM