Sometimes the simplest features can be the lifesavers! Today’s tip is no different.
Have you ever had a list of names or other data that need split? In my example, I have a roster of students’ full names. This is not ideal, because I’d like to have them split by first and last so I can sort and perform other operations.
Previously, you would have to use something like the Power Tools add-on. I LOVED this add-on, but alas, it’s no longer free. But don’t fret… because this feature is now built-in to Google Sheets!

I’m Chris Malanga and I’ve been an Educational Technologist with the Northern Buckeye Education Council/NWOCA since 2016. In this role, I help teachers, administrators, and students integrate technology into our schools. My passion is helping people develop skills to change the world of education!