Split
SPLIT_NAME
Splits full names into first, middle, last, title, and suffix columns.
Syntax
=SPLIT_NAME(full_name, [include_headers], [include_metadata])Parameters
NameTypeDescription
Name
full_nameTypetext or range
DescriptionFull name text, or a range containing full names.
Name
include_headers?Typeboolean
DescriptionTRUE to add a header row. Defaults to FALSE.
Name
include_metadata?Typeboolean
DescriptionTRUE to add confidence and compound-surname columns. Defaults to FALSE.
Returns
A spilled table with first, middle, last, title, and suffix columns.
Example
=SPLIT_NAME("Dr. Martin Luther King Jr.")Result: Martin | Luther | King | Dr. | Jr.
Notes
Range inputs are supported. SPLIT_NAME flattens the input range into one output row per name.
The parser handles titles, suffixes, comma-formatted names, and common surname particles such as van, von, de, del, and de la.
All parsing runs locally inside the spreadsheet with no external API calls.