Get edit link URL in Google Sheets

  • gleninneswaste
    Asked 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 Lead
    Replied 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:

    screenshot 4443 Screenshot 10

    You can also use the following formula to extract the text value from the hyperlink:

    =REGEXEXTRACT(FORMULATEXT(D2),"""(.*)"",")


    screenshot 4445 Screenshot 21

    Let us know if you have any additional questions.