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("http://twitter.com/guardian/status/941765632642691073", "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 | http://twitter.com/guardian/status/941765632642691073 |

Tags : google-sheets


Related Questions




Copying values between google sheets

Updated July 26, 2018 21:03 PM