For example, there is data that contains a string in column A.
If the link is set halfway as shown in the image,
I would like to set up a script to set up hyperlinks only for strings with no links.
I've looked into various things, but I don't know how to determine if the link is set.
Please let me know if anyone knows.
数字 The numbers are appropriate.
google-apps-script google-spreadsheet
I don't think it's an ideal solution, but I think the code on this site will help you with the link decision part.
[Useful with GAS] Extract all links in the sheet
© 2024 OneMinuteCode. All rights reserved.