How to Split First and Last Name in Google Sheets: A Step-by-Step Guide

Splitting first and last names in Google Sheets might seem tricky, but it’s actually quite simple. With just a few clicks, you can separate full names into individual columns for first names and last names. This can be handy when organizing data, creating mailing lists, or simply for better readability.

Step by Step Tutorial on How to Split First and Last Name in Google Sheets

Before diving into the steps, let’s understand what we’re aiming for. We’ll be using a function in Google Sheets that automatically detects spaces in a cell and splits the contents based on that space. This means that “John Doe” would be split into “John” in one cell and “Doe” in another.

Step 1: Select the cells with names

The first thing you need to do is select the cells that contain the full names. Click and drag your mouse over the cells to highlight them.

Selecting the correct cells is crucial because this function will only work with the highlighted area. Make sure you don’t include any empty cells or cells with different types of data.

Step 2: Go to the Data menu

With the cells still highlighted, navigate to the top of your screen and click on the “Data” menu. This is where you’ll find the tools needed to manipulate your data.

The Data menu is home to many powerful tools in Google Sheets. Familiarizing yourself with these can make you a spreadsheet pro in no time!

Step 3: Click on “Split text to columns”

In the Data menu, look for the option that says “Split text to columns.” It might be a little buried, but it’s there. Click on it.

This function is specifically designed to take a chunk of text and divide it into separate columns based on a delimiter, which is a fancy word for a specific character like a space or a comma.

Step 4: Choose “Space” as your separator

After clicking “Split text to columns,” a small menu will appear at the bottom of your screen asking you to choose a separator. Click on “Space.”

Names are typically separated by spaces, so choosing “Space” as the separator is your best bet. If the names are hyphenated or have additional titles, you may need to repeat the process with different separators.

Step 5: Check the results

After choosing your separator, Google Sheets will automatically split the names into two columns. Take a look and make sure everything looks right.

Sometimes, if there’s an extra space or unusual formatting, the split might not work as expected. If that’s the case, you can always use the “Undo” function and try again.

After completing these steps, you’ll have a neatly organized spreadsheet with first and last names in separate columns. This can make your data much more manageable and easier to work with.

Tips for Splitting First and Last Name in Google Sheets

  • Always make sure there’s a consistent format in the names column before you begin. This ensures a clean split.
  • If you have middle names in the mix, you might need to do a bit of manual editing after the split.
  • Consider adding new columns before you split the text, so you don’t overwrite any existing data.
  • Use the “Undo” function liberally if you make a mistake. It’s your best friend here.
  • For names with titles (like Dr., Mr., Mrs.), you may need to use the “Custom” separator option and type the title followed by a space.

Frequently Asked Questions

What if there are middle names included?

If the cell contains a middle name, the “Split text to columns” function will split it into another column. You may need to manually adjust the cells if you only want the first and last name.

Can I split names that are separated by commas?

Yes, you can. In Step 4, instead of choosing “Space,” you would choose “Comma” as your separator.

What if I need to split a lot of names at once?

The steps provided work for any number of names. You simply need to highlight all the cells you want to split before going through the process.

Can I combine first and last names in Google Sheets?

You sure can. You can use the CONCATENATE function or the ampersand (&) symbol to join names back together in a new cell.

What if the function doesn’t work?

Make sure there aren’t extra spaces or different formatting in the names. If it still doesn’t work, try refreshing the page or checking Google Sheets help forums for more troubleshooting tips.


  1. Select the cells with names.
  2. Go to the Data menu.
  3. Click on “Split text to columns.”
  4. Choose “Space” as your separator.
  5. Check the results.


Mastering how to split first and last name in Google Sheets can save you a ton of time and headaches. Whether you’re a teacher organizing student data, a business owner segmenting customer information, or just someone who loves a well-organized spreadsheet, this skill is a fantastic addition to your toolbox. Remember, Google Sheets is more than just a place to store numbers—it’s a powerful tool for data manipulation and organization. The more you play around with its features, the more efficient you’ll become. So go ahead, give it a try, and watch your spreadsheet game level up!

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy