NAMESPLIT reference
NAMESPLIT
Split contact names into first, middle, last, title, suffix, confidence, and formatted outputs with formula-first Google Sheets functions.
CRM contact cleanup
Turn full-name columns from forms and exports into first, middle, last, title, and suffix fields.
Mail merge prep
Format names as Last, First or formal display names before pushing data into templates.
Auditable parsing
Use confidence scores and compound-surname flags to review ambiguous records before bulk imports.
Components
5 functionsSPLIT_FIRST_NAMEExtracts the first name from a full name.
SPLIT_MIDDLE_NAMEExtracts the middle name from a full name.
SPLIT_LAST_NAMEExtracts the last name, including supported compound surname particles.
SPLIT_TITLEExtracts the title or salutation from a full name.
SPLIT_SUFFIXExtracts the suffix from a full name.
Metadata
3 functionsFormat
4 functionsNamespaced Aliases
13 functionsNS_SPLITCollision-resistant alias for SPLIT_NAME.
NS_FIRSTCollision-resistant alias for SPLIT_FIRST_NAME.
NS_MIDDLECollision-resistant alias for SPLIT_MIDDLE_NAME.
NS_LASTCollision-resistant alias for SPLIT_LAST_NAME.
NS_TITLECollision-resistant alias for SPLIT_TITLE.
NS_SUFFIXCollision-resistant alias for SPLIT_SUFFIX.
NS_CONFIDENCECollision-resistant alias for SPLIT_NAME_CONFIDENCE.
NS_HAS_COMPOUND_SURNAMECollision-resistant alias for HAS_COMPOUND_SURNAME.
NS_JSONCollision-resistant alias for SPLIT_NAME_JSON.
NS_FORMAT_LAST_FIRSTCollision-resistant alias for FORMAT_NAME_LAST_FIRST.
NS_FORMAT_FIRST_LASTCollision-resistant alias for FORMAT_NAME_FIRST_LAST.
NS_FORMAT_FORMALCollision-resistant alias for FORMAT_NAME_FORMAL.
NS_INITIALSCollision-resistant alias for GET_INITIALS.