Google Sheets: Split a List of Names

Google Sheets: Split a List of Names

split names google sheets

I like to use listofrandomnames.com to create sample students. This comes in handy quite often. This gives me a list of first and last names. Oftentimes I want the first and last names separated. You can also do this with your actual student names. Copy your roster of students and paste into a Google Sheets spreadsheet. If the names are already in a Google Sheets spreadsheet, highlight the names, copy and immediately paste into the same range of cells.

List of Random Names

If you want to use listofrandomnames.com, copy the “list from a text area”
list of names

Paste

When you paste into a Google Sheets spreadsheet, notice a clipboard icon shows up in the bottom right.
Clipboard

Split

Clicking on the clipboard icon reveals the option to “Split text to columns.”
split text to columns

Space

If your roster is listed as “First Last” then the words are separated by a space. The default separator is “comma.” Choose “Space” from the list instead. This will cause the spreadsheet to “eat” your spaces and place the individual words between the spaces into a new cell.
space delineated

Split list of names

Thanks @googledocs for the heads up 🙂

=Split()

For those of you who, like me, enjoy writing formulas in a spreadsheet =Split(A2,” “) works also to split a list of names, separated by a space.

If you have “Last, First” you can use =split(A2,”, “) where the comma space is the separator.

2 thoughts on “Google Sheets: Split a List of Names

  1. We are a GAFE school. I just tried to split names. I copied from from a document that had students first and last name. I then pasted it into a Sheet. When I clicked on the clipboard icon, bottom right corner of the Sheet, I only got two options. The options are: Paste Values Only, or Paste Format Only.

Leave a Reply

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Discount applies until you cancel!! 
Normally $12 a month, save 58%!! 

Monthly installments of only $4.99 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.