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 ...
You have the basic concept right just piece it together step by step. This does the job:
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 ...