Split full names into first and last name in Excel (incl. van/de)
Separate names for CRM and mailing imports without breaking prefixes like “van der”.
The message you see
How to split full names into first and last nameFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Text to Columns splits on every space, so “Jan van der Berg” becomes four columns.
- Middle names, titles and double surnames vary per row.
How to fix it
- 1Work on a copy and keep the original full-name column.
- 2Split into first name, prefix and last name, then review unusual rows.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support