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!


The #1 resource for Google Apps how-to videos. Follow The Gooru to keep up to date on the latest Google Apps features, news, updates and more! You can also check out The Gooru's library of Google Drive Training videos and Gmail Training videos!



  1. Pingback: EdTech Explorations » Blog Archive » Cool Tools and Resources to Explore 09/01/2013

  2. Tammy

    Thanks for this great tip!! How do I make this script available for any of my open spreadsheet files? It seems to only be available for the one spreadsheet where I created it.

  3. Mike McKenna

    Great video. Thanks for posting. Quick question: where does the script reside? I don’t see it in my Google Drive.

  4. kathy

    this is the best. Took me 5 minutes to setup and now I have a one-button solution to a task I do all the time.

  5. Pingback: Google Docs Columns | پرتال جامع فان گستر

  6. kojak edwards

    What a disappointment. When I clicked on the .txt file, it was empty. When I looked up Google Script Apps, it was nowhere to be found.

    The only winner in all of this is Google Gooru. They get to sell my email address. I guess I can expect a boatload of spam/advertising.


Leave a Reply

Your email address will not be published. Required fields are marked *