- SHARE →
Here is a TXT file containing the code for the Apps Script used in the video – view TXT file
With this script, you can finally select a group of column of cells and split them according to a certain character (e.g. comma, space, @ sign, etc.), just like you can do in Excel with the “Text to Columns” function.
This should be in the Apps Script Gallery soon, but in the meantime you can just create your own using the TXT file above.
Time to see how many days I can go without opening Excel!