How to do text-to-columns in Google Spreadsheets

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!

Comments (8) Write a comment

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

  2. 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.

    Reply

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

    Reply

Leave a Reply

Required fields are marked *.