How to Split a Full Name into First and Last Names in Google Sheets
Split Full Name into First and Last is a Google Sheets function that splits a full name into separate first and last name components based on the space between them.. Formula Genius generates and validates this formula automatically from a plain-English prompt.
Struggling to separate names in your spreadsheet? This guide shows you how to efficiently split full names into first and last names using a simple formula.
The Formula
"Split a full name in one cell into first name and last name in separate columns"
=SPLIT(A1, " ")This formula splits a full name into separate first and last name components based on the space between them.
Step-by-Step Breakdown
- Identify the cell containing the full name (e.g., A1).
- Use the SPLIT function to divide the text.
- Specify the delimiter, which is a space in this case.
- The function will output the first name in one cell and the last name in another.
Edge Cases & Warnings
- Names with middle names will result in additional columns.
- Names with no spaces will return the full name in one cell.
- Names with extra spaces will create empty cells in the output.
Examples
"John Doe"
John, Doe"Jane Smith"
Jane, SmithFrequently Asked Questions
What if the name has a middle name?
The SPLIT function will create additional columns for each name component.
Can I split names with different delimiters?
Yes, you can change the delimiter in the SPLIT function to accommodate different formats.
How do I handle names with extra spaces?
You may need to use the TRIM function to remove extra spaces before splitting.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.