Format
FORMAT_NAME_FIRST_LAST
Formats a parsed name as "First Middle Last".
Syntax
=FORMAT_NAME_FIRST_LAST(full_name)Parameters
NameTypeDescription
Name
full_nameTypetext or range
DescriptionFull name text, or a range containing full names.
Returns
A formatted name string. Range input spills results.
Example
=FORMAT_NAME_FIRST_LAST("Dumbledore, Albus Percival, Prof.")Result: Albus Percival Dumbledore
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.