Split Names Into Two Columns in Google Sheets


Have you ever had a spreadsheet containing a list of names and needed to split them into separate columns for first and last names? You usually would have to write a complex formula to orchestrate such a simple task, but the Split Names add on for Google Sheets removes the need for formulas.

Sorting a spreadsheet of students by last name has never been easier. Just highlight the selection and click split! The add on can even separate middle names, titles, and suffixes.

Click here to watch this video on YouTube.

Get the best tips and tricks in your inbox daily