Gooru Tip - Maximize the video player and adjust video quality for optimal viewing!
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!
Thanks for the helpful video. This saves me from exporting to Excel.
You can also do this using the SPLIT formula http://support.google.com/drive/bin/answer.py?hl=en&answer=155358 e.g. in cell B1 I could enter =SPLIT(A1, ” “)
Excellent quick tutorial and the script is great. It really is one of the annoying things I kept having to open Excel for. Thank you!