Easily convert text to columns in Google Sheets

We know that copying data and pasting it into a spreadsheet can be a pain if the data does not separate neatly into columns. Google is launching a feature in Sheets that allows you to split data from one column across multiple columns.

There are a few ways you can split delimited data across columns. For example, you can select the columns you want to split, and click Data > Split text to columns. A menu will then appear underneath the data, allowing you to split the data using commas, semicolons, periods, spaces, and even custom separators.

In addition to the “Split text to columns” option, you can also format cells containing data using a contextual menu that appears immediately after you’ve pasted data, as shown in the animation below.

Comments

Post a Comment

Popular posts from this blog

Cleaning up for EOY

Image
The end of the school year is here and it is a great time for students and staff to cleanup your email and drives before you leave for the summer.  Here are a few best practices and tools to help you. Student/Staff Drives: It is a good idea to backup all files on your school based drives before you leave for the summer. Refer to your EOY checkout sheets for your school process. Remember that the student share drive  will be deleted  this summer so remove any files you wish to keep. Google Takeout: Go to:  https://www.google.com/ settings/takeout To create an archive of all files on up to 16 different Google products including Drive and Gmail. This process is free and very simple, just follow the onscreen directions as shown below. 1. Create an archive by selecting the services you wish to archive: 2. Select your file download type and delivery method (by default all files will download as a zip file): 3. Click Create Archive, you will then
Read more

Insert Images into your Quizzes using Google Quizzes aka Forms

Image
You can now add images to your answer choices in Google Forms. Doing that allows you to have students select an image as the response to a question. You can also combine images and text in your Google Forms answer choices. It also allows you to select answer key, point value, and feedback!  Check out this video for step by step instructions:  Insert Images as Answer Choices  
Read more

2016 Microsoft Office for Home Use

Image
Microsoft Office for Home Use includes  Microsoft Office Professional Plus 2016 Or if you use a Mac, get Office Home and Business 2016 for the same low price $9.95. Go to:  http://www.microsofthup.com/hupus/home.aspx Enter your work email and follow the on screen instructions!
Read more