Excel-handleiding

How to split a full name into first and last name in Excel

Splitting full names into separate columns is a common task for data cleaning. You can use the built-in Text to Columns tool for a quick fix or formulas for dynamic updates.

Doe het met AI

Stap voor stap

1
Select the data range
Highlight the cells containing the full names you want to split.
2
Open Tekst naar kolommen
Go to the 'Data' tab on the ribbon and click 'Text to Columns'.
3
Configure the wizard
Choose 'Delimited', click 'Next', check the 'Space' box, and click 'Finish'.

=LEFT(A2, FIND(" ", A2)-1) & " " & RIGHT(A2, LEN(A2)-FIND(" ", A2))

Tips

Use Flash Fill (Ctrl+E) for an even faster, non-formula approach.

Veelgestelde vragen

What if names have middle initials?

Text to Columns will split every word separated by a space into a new column.

Gerelateerde handleidingen

How to Use Flash Fill in Excel