Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Docs – Text to Columns in a spreadsheet

Google Docs – Text to Columns in a spreadsheet

If you are an avid excel user like me then you probably like the text to columns feature which will take one cell and split it into multiple cells based on a delimiter.  I use this a lot when I have a spreadsheet that has peoples names in it.  Oftentimes the first and last name are together in the same cell.  Text to Columns helps me to seperate them.

However, I am a big fan of Google docs, so how do I do this same feature in Docs?  Use the function =SPLIT(array, delimiter).  So for example I had a spreadsheet that had First Last in the same cell.  So I inserted two blank columns and in the first column, in cell D2, I put in =Split(C2,” “) where I put a space in between quotation marks (a requirement when telling excel you have text).  The first name was put in cell D2 and the last name was put in cell E2.  Unlike excel the original column was untouched, so just be aware you’ll have additional data columns.

2 thoughts on “Google Docs – Text to Columns in a spreadsheet

  1. This is a great tip and much easier than copy/pasting into Excel and using Text to Columns. Thanks again for another timesaving technique Alice!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Regular price is $249. Save $150 and pay only $99 for the 2024/2025 school year!

Monthly installments is only $12 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.