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 |