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 name
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Split my names →

Why this happens

How to fix it

  1. 1Work on a copy and keep the original full-name column.
  2. 2Split into first name, prefix and last name, then review unusual rows.

Related guides

Still stuck? Ask SheetFix Support