Wednesday, March 2, 2016

Google Apps Update: Split Text in Columns in Google Sheets



Google Apps update alerts

Link to Google Apps update alerts

Posted: 01 Mar 2016 01:55 PM PST
We know that copying data and pasting it into a spreadsheet can be a pain if the data does not separate neatly into columns. With that in mind, today we're launching a feature in Google Sheets that allows you to split delimited data (e.g. data separated by commas) 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 delimited data using a contextual menu that appears immediately after you’ve pasted data, as shown in the animation below. You can choose a custom separator through this method also. See the Help Center to learn more.



Launch Details
Release track:
Launching to Rapid release, with Scheduled release coming in two weeks.

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
All end users

Action: Change management suggested/FYI

More Information
Help Center

Tuesday, March 1, 2016

How to Print all Assignments in Google Classroom



Many people are using Google Classroom with their students and co-teachers, but many are asking for an option to print all student assignments at once while in Google Classroom.

Currently, there is not a way to do this in Google Classroom.  However, there are many workarounds for this.

First, you can install the app PDF Mergy, from the Chrome Web store into your Google profile.  This app will allow you to drag and drop files from your device or from your Google Drive and it will merge all of your files into one file.  Then you can simply print the file.  

In addition,  PDF Mergy will allow you to save your merged file to your local device or to your Google Drive.  You can also give it a more descriptive name.  

I created a short screen cast  Enjoy!