Paste the names
One full name per line, in the order first name then surnames, or as Surname, Name.
Paste full names, one per line, and get columns for the first name and the surname or surnames, ready to paste into a spreadsheet. Names like José Luis or de la Fuente are handled.
100% private — your text is processed in your browser and never sent to any server.
One full name per line, in the order first name then surnames, or as Surname, Name.
Spanish style with two surnames, or a single last name.
Paste them into a spreadsheet: each part lands in its own column.
Databases, mail merges and forms usually want the first name and the surname in separate fields, but names often arrive in a single column: from a customer list, an event registration or a copied directory. Splitting them by hand, or with a spreadsheet formula that cuts at the first space, goes wrong quickly, because names are not that regular. This tool applies sensible rules to split a whole list at once.
If your list has a known pattern, for example every person has two first names, set the number of words in the first name to 1, 2 or 3 instead of leaving it on detection. The tool then applies it to every line. The result is tab-separated, with an optional header row, so it pastes straight into a spreadsheet.
Names are one of the hardest kinds of text to split with certainty. A three-part name can be one first name and two surnames, or two first names and one surname, and nothing in the text says which; the tool uses a list of common compound first names to decide and warns you how many names it had to guess. Names with four or more parts, names from other cultures where the family name comes first, and unusual particles may need a manual check. Do not use the result for legal or official records without reviewing it.
It does not validate that a name is real, correct spelling, change capitalisation or remove titles such as Dr. or Mr.. To fix capitalisation before or after splitting, use the case converter.
With the full name in A2 (here Ada Byron Lovelace):
| To get | Formula | Result |
|---|---|---|
| First word | =LEFT(A2, | Ada |
| Everything after the first word | =TRIM(MID(A2, | Byron Lovelace |
| Last word | =TRIM(RIGHT(SUBSTITUTE(A2, | Lovelace |
| Each word in its own cell (Microsoft 365) | =TEXTSPLIT(A2, | Ada | Byron | Lovelace |
| Each word in its own cell (Google Sheets) | =SPLIT(A2, | Ada | Byron | Lovelace |
The formulas use English function names and commas. If your Excel or Google Sheets is set to another language, the function names change, and in many countries the separator between arguments is a semicolon.
Anna Mariais one first name or that
de la Cruzis one surname. For names like that, review the result or use the tool, which lets you choose the pattern.
TEXTSPLIT exists in Excel for Microsoft 365 and Excel 2024 and later, not in Google Sheets; SPLIT is the Google Sheets function.=LEFT(A2,FIND(" ",A2&" ")-1) gives the first word and =TRIM(MID(A2,FIND(" ",A2&" ")+1,100)) the rest. In Microsoft 365, =TEXTSPLIT(A2," ") does it in one step.More utilities that also run without leaving your browser.