Google Sheets: Split Text to Columns

by | Nov 6, 2016 | Google, Intermediate, Sheets | 0 comments

Google Sheets: Split Text to Columns

When you copy and paste into Google Sheets you will notice an option will automatically appear allowing you to split the text into columns. Choose the delineator and poof, text is split.
split text to columns

Data Menu

You can also manually activate text to columns by highlighting your data and choosing “Split text to columns” from the Data menu.
split text to columns data menu

Eats Data

Note that choosing to split text to columns will eat the data in adjacent columns. Tip to insert blank columns before splitting your text to columns.

Digiprove sealCopyright secured by Digiprove © 2016

Related Alice Keeler blog posts:

  1. Peer Evaluation in Google Classroom
  2. Google Sheets: Format Painter Saves the Day
  3. Math Puzzle, Get Students Thinking
  4. Google Classroom: Spiral Review on the About Tab

Leave a Reply

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

50% Off February Special

Online Workshops for Google Sheets, Classroom, Slides and more are 50% off for February. Use the discount code february at checkout. Also annual subscriptions for access to all of the Go Slow online workshops are 50% off!

catching snowflakes on your tongue

alicekeeler.com/goslow