-
gleninneswasteAsked on March 23, 2021 at 12:28 AM
Hi can you tell me how to get Google Sheets to capture the edit link URL (not just they hyperlink)?
-
Bojan Support Team LeadReplied on March 23, 2021 at 7:05 AM
Greetings.
Unfortunately, it is not possible to send the text value of the edit link. You can always click on the link and then copy the URL from the Sheet:
You can also use the following formula to extract the text value from the hyperlink:
=REGEXEXTRACT(FORMULATEXT(D2),"""(.*)"",")
Let us know if you have any additional questions.