Separate Name
Separate Name splits a single full-name column into first and last name in one step.
What it does
- Reads a column holding a full name
- Writes First Name and Last Name into new columns
- Does in one action what Get First Name and Get Last Name do separately
How to use it
- Click Add Action and search “Separate Name”
- Select the column containing the full name
- Run the row, then the column
Common use cases
- Split a Full Name column that arrived from a scrape or a CSV
- Fill the separate first and last name fields a CRM expects
- Produce both personalization tokens in one step before writing copy
- Normalize names before deduping on name + company
Best practices
- Check the rows that break the pattern — middle names, suffixes like Jr. or PhD, two-word surnames
- Clean the column first if it also holds a title: “Jane Doe, VP Sales” does not split cleanly
- Reformat ALL CAPS or lowercase names with Formula Generator before splitting
- Keep the original full-name column; you will need it to spot-check the split
- Filter for rows where either output is empty before you send anything using the tokens
Where to next
- Get First Name — just the first name, if that’s all you need
- Merge Columns — the reverse: combine first and last back into one column