Skip to content

Split Names Into Two Columns in Google Sheets

< 1 minute read

Sheets Yellow1

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.

Sign up for our newsletter