Split a full name into first name and surname, without formulas
Mail merges, CRMs and bulk SMS tools want first names on their own. Open your list, choose the name column, and it splits at the first space: the first name, and the rest.
Drop your CSV here
Split names opens ready. Nothing is sent until you save.
At the first space, or every one
First name and the rest, or a piece per word, comma or any character you choose.
Join columns too
Put First name and Surname back together, with a space, comma or dash between.
Capitals fixed
ADA OBI and ada obi become Ada Obi, with McDonald and hyphenated names kept right.
Undo it
Every change is one step back.
Questions people ask
What happens to middle names?
Splitting at the first space puts the first name in one column and everything else in the next.
Can I keep the original column?
Yes. Tick the box to keep it before splitting.
What about Excel files?
Save the sheet as CSV first, then open it here.
Is it free?
Yes.