Clean

Separate honorifics, first names, middle initials, surnames, and generational suffixes

Extract professional titles (Dr., Rev.) and suffixes (Jr., III, Ph.D.) into distinct columns.

🛡️ Your rows never leave your browser.

Why Onfyt: Correctly handles compound surnames (Van der Valk, De La Hoya) so family name particles don't get shifted into middle names.

Interactive Sample Data

id	full_name
1	Dr. Evelyn M. Reed, Jr.
2	Prof. Charles Xavier Ph.D.
3	Ms. Grace Kerubo

How this tool works

Naive string splitting on whitespace breaks down the moment a dataset encounters professional titles, religious honorifics, compound middle initials, or generational suffixes. A split on space will incorrectly interpret 'Dr.' as a first name, 'Reed' as a middle name, and 'Jr.' as a last name, ruining email personalization tokens and mail merge campaigns. Accurate name parsing requires hierarchical token analysis. The engine first scans the beginning of the string against a comprehensive lexicon of honorific prefixes (Mr., Mrs., Ms., Dr., Prof., Rev., Sir, Hon.). It then inspects the end of the string for generational or academic suffixes (Jr., Sr., II, III, IV, Esq., MD, PhD, DDS). The remaining central tokens are parsed into given names, middle names or initials, and family names, taking into account compound surname prefixes such as 'Van', 'De', 'Mac', and 'Del'. DataFix runs this rule-based name segmentation directly on your device. Whether your data uses standard Western ordering ('Dr. Jane Doe') or reversed comma notation ('Doe, Dr. Jane, Jr.'), each component is cleanly isolated into its own dedicated column without cloud dependencies.

Things that usually go wrong

Names in 'Last, First' format must be flagged with 'Inverted name' toggle.
Compound last names (de la Cruz, van der Berg) may be split at the first component — review these manually.

Edge cases we tested

🧪 Academic post-nominal letters ('MD', 'PhD', 'Esq.')

Categorized into the suffix column rather than treated as a last name.

🧪 Single word mononyms ('Cherono', 'Prince')

Populates first_name; leaves title, middle, last, and suffix empty.

🧪 Reversed comma syntax ('Reed, Dr. Evelyn, Jr.')

Identifies family name correctly regardless of token ordering.

Frequently Asked Questions

What titles are recognised?

Dr., Mr., Mrs., Ms., Miss., Prof., Rev., Sir, Dame, and their variants.

What suffixes are recognised?

Jr., Sr., II, III, IV, Esq., PhD, MD, CPA, and their variants.

What happens with names that have no last name (mononyms)?

Mononyms (single-word names common in Indonesia, Ethiopia, and parts of Africa) are placed in the last_name field. The first_name and middle_name fields are left empty.

How are hyphenated last names handled?

Hyphenated names (Smith-Jones, Okonkwo-Eze) are kept intact as a single last name. They are not split at the hyphen.

Related tools

Clean

Split Full Name into First and Last

Separate full name columns into dedicated first_name and last_name columns in CSV and Excel spreadsheets.

Open Tool →

Clean

Combine First and Last Name

Merge separate first and last name columns into a single clean full_name column, trimming extra spaces.

Open Tool →

Clean

Remove Duplicate Rows

Eliminate duplicate rows across your entire dataset or based on specific unique key columns.

Open Tool →