Google Sheets: Split Text to Columns

split text to columns

EdTech Books by Alice Keeler

  • Student Engagement
  • Google Classroom
  • Student Centered Classrooms
  • Google Apps for Littles
  • Math and Google Apps
  • Ditch That Homework
Google Sheets: Split Text to Columns

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.

Leave a Comment

© 2025 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

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