Guida Excel

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.

Fallo con l'IA

Passo passo

1
Select the data range
Highlight the cells containing the full names you want to split.
2
Apri Testo in colonne
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))

Suggerimenti

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

Domande frequenti

What if names have middle initials?

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

Guide correlate

How to Use Flash Fill in Excel