Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Facebook Twitter Youtube Cloud-sun Music

Google Sheets: Split Text to Columns

Alice Keeler

Alice Keeler

split text to columns
Convert Google Jamboard
JAMBOARD DISCONTINUED: It is urgent that you convert your Jamboard Jams to FigJam.
Learn More
Teacher Tech Newsletter
Subscribe to Alice Keeler's newsletter for the latest Teacher Tech tips and innovative EdTech insights!
Click Here
2023 EdTech Cruise
Follow #EdTechCruise to share in the adventure. Visit our sponsor xSoTec for custom Google Apps solutions
Visit xSoTec
Previous slide
Next slide

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.

Recent Teacher Tech Blog Posts

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

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

%d