How do I separate names in Excel?

To separate names in Excel, select the full-name column and go to Data → Text to Columns → Delimited, then tick Space so the first and last name land in separate columns. Formulas (LEFT/RIGHT/FIND) or Flash Fill do the same thing. Sigmera separates a full-name column in one click in your browser, with no upload, and handles middle names automatically.

How do I separate text into columns in Excel?

Use Text to Columns: select the column, open Data → Text to Columns, choose Delimited, and pick the character that separates the values (a space for names, a comma for CSV-style text). Excel writes each part into its own column. Set a Destination cell first so you do not overwrite the original data.

How do I split first and last name in Excel?

Select the name column, go to Data → Text to Columns, choose Delimited, tick Space as the delimiter, set a destination cell, and click Finish. Excel splits each name at the space into separate columns. For two-word names this gives a clean first and last name in two columns.

How do I split names without Text to Columns?

Use formulas. For the first name use =LEFT(A2, FIND(" ", A2) - 1). For the last name use =RIGHT(A2, LEN(A2) - FIND(" ", A2)). Or, in Excel 2013 and later, type the first split result manually and press Ctrl+E to trigger Flash Fill, which detects the pattern and fills the rest.

How do I handle middle names or two-word last names?

Text to Columns splits on every space, so 'Mary Jane Watson' becomes three columns. To keep everything after the first space as the last name, use =MID(A2, FIND(" ", A2) + 1, LEN(A2)) for the last name and =LEFT(A2, FIND(" ", A2) - 1) for the first name. Tools that detect name structure handle these cases automatically.

How do I split names in Google Sheets?

Select the column and choose Data → Split text to columns, then pick Space as the separator. Or use the SPLIT function: =SPLIT(A2, " ") spills the parts across columns. =INDEX(SPLIT(A2," "),1) returns just the first name.

Why does Text to Columns overwrite my data?

By default Text to Columns writes the results starting in the original column, overwriting whatever is to the right. Always set the Destination in the final wizard step to an empty cell, or copy the name column to a blank area first so the original list is preserved.

How to split full names in Excel

To split names in Excel, select the full-name column, open Data → Text to Columns, choose Delimited, and tick Space as the delimiter so the first and last name land in separate columns. For an error-proof option that handles middle names automatically, Sigmera splits a full-name column in one click, in your browser, with no upload.

Last updated: June 2026

Split names in Excel with Text to Columns

Text to Columns is the standard way to split a full-name column. It splits each cell at a chosen character — here, the space between words — and writes each part into its own column.

1. Select the name column. Highlight the column of full names, and leave at least two empty columns to the right for the results.
2. Open Text to Columns. On the Data tab, click Text to Columns, choose Delimited, and click Next.
3. Choose the space delimiter. Tick Space so each word goes to its own column. Check the live preview, then click Next.
4. Set the destination and finish. Pick the first empty destination cell so the original column is not overwritten, then click Finish.

Split names with formulas

If you want the split to update automatically when names change, use formulas instead. For the first name:

=LEFT(A2, FIND(" ", A2) - 1)

For the last name:

=RIGHT(A2, LEN(A2) - FIND(" ", A2))

To keep everything after the first space as the last name (useful for two-word surnames), use =MID(A2, FIND(" ", A2) + 1, LEN(A2)).

Use Flash Fill (Excel 2013+)

In the column next to your names, type the first name from row 1, then start typing the second and press Ctrl + E. Flash Fill detects the pattern and fills the rest of the column. Repeat in a new column for last names. Flash Fill is fast but does not update when the source data changes.

Split names in Google Sheets

Select the column and choose Data → Split text to columns, then pick Space as the separator. Or use the formula =SPLIT(A2, " ") to spill the parts across adjacent columns automatically.

Faster way → do it in one click with the free Split Full Names tool, no upload. It separates first and last name, handles optional middle names, and previews the result before you download.

Do this in 1 click — free

Manual Excel vs Sigmera, compared

Method	Time	Handles edge cases	Skill needed
Sigmera (this tool)	Seconds, one click	Detects middle names; first/last in one pass; live preview	None
Text to Columns	A minute (wizard)	Splits on every space; middle names break it	Low (menus)
LEFT/RIGHT/FIND formulas	Several minutes	Manual handling for middle and two-word names	Medium (formulas)

Frequently asked questions

How do I separate names in Excel?: To separate names in Excel, select the full-name column and go to Data → Text to Columns → Delimited, then tick Space so the first and last name land in separate columns. Formulas (LEFT/RIGHT/FIND) or Flash Fill do the same thing. Sigmera separates a full-name column in one click in your browser, with no upload, and handles middle names automatically.
How do I separate text into columns in Excel?: Use Text to Columns: select the column, open Data → Text to Columns, choose Delimited, and pick the character that separates the values (a space for names, a comma for CSV-style text). Excel writes each part into its own column. Set a Destination cell first so you do not overwrite the original data.
How do I split first and last name in Excel?: Select the name column, go to Data → Text to Columns, choose Delimited, tick Space as the delimiter, set a destination cell, and click Finish. Excel splits each name at the space into separate columns. For two-word names this gives a clean first and last name in two columns.
How do I split names without Text to Columns?: Use formulas. For the first name use =LEFT(A2, FIND(" ", A2) - 1). For the last name use =RIGHT(A2, LEN(A2) - FIND(" ", A2)). Or, in Excel 2013 and later, type the first split result manually and press Ctrl+E to trigger Flash Fill, which detects the pattern and fills the rest.
How do I handle middle names or two-word last names?: Text to Columns splits on every space, so 'Mary Jane Watson' becomes three columns. To keep everything after the first space as the last name, use =MID(A2, FIND(" ", A2) + 1, LEN(A2)) for the last name and =LEFT(A2, FIND(" ", A2) - 1) for the first name. Tools that detect name structure handle these cases automatically.
How do I split names in Google Sheets?: Select the column and choose Data → Split text to columns, then pick Space as the separator. Or use the SPLIT function: =SPLIT(A2, " ") spills the parts across columns. =INDEX(SPLIT(A2," "),1) returns just the first name.
Why does Text to Columns overwrite my data?: By default Text to Columns writes the results starting in the original column, overwriting whatever is to the right. Always set the Destination in the final wizard step to an empty cell, or copy the name column to a blank area first so the original list is preserved.