New answers tagged

-1

I followed this tutorial: YouTube Link To summarize it's content: it used Start function from Power Tools Add-On. As you will see in the video and in your sheet, if you edit the cell having a URL and write one space more after the link and then finalize your cell editing, the link appears as clickable. So the function used makes this 'modification' in a ...


2

You have the basic concept right just piece it together step by step. This does the job: =REGEXREPLACE(JOIN(" ",ARRAYFORMULA(IFERROR( REGEXEXTRACT(SPLIT(A1," ",TRUE,TRUE), "https://example.com/(\S+)"),""))),"\s+"," ") You split the string at whitespaces, this is safe because URLs don't contain white space so you're definitely not breaking them up. This ...


Top 50 recent answers are included