Convert cells into links based on the cells' data. Fast and convenient way to link to more information.
Text2Link allows you to add a link to cells of plain text, where the link built contains the text of the cell somewhere in it. If you know that the text within your cells are used to build a URL or Web address, you can use Text2Link to build and attach that link to your cells.
MyTaskSite.com/taskpage?task=(my task number here)
Let's say you have a column of task numbers that have a corresponding task webpage based on the URL above. You can create a formula in Text2Link that can then be used to convert all your cells of text to have a link as well.
Your cell text is "%s" so, in this case, the Text2Link formula would be, where %s is your cell text:
Then run the Text2Link add-on over selected cells and you're done! Now all cells are linked to webpages and you can access them whenever you want. Saves time, especially when there are many cells to link.
As you browse, see how the webpage URL/Web address is built and see how Text2Link can benefit you today.
Add-on comes with two working examples for you to quickly see how it works and it's easy to create your own! There is no limit to the amount of links you can keep on hand for easy reference. Link to most webpages to accomplish your web-based productivity needs (search results, site webpages, Server-side utility pages, etc).
FAQ also included to find answers to common questions.
Like this? Check out the Google Docs version at:
Published to G Suite Marketplace