Split names
Use the Split names step to split a full name value into smaller parts (first, middle, last, etc.).
Input/output
Your input data should consist of a column of full names.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/67a54d8724413b0bfdce4857_66070ac2ee985a0c091b6043_Screenshot%25202024-03-29%2520at%25202.38.49%2520PM.png)
Your output will have multiple new columns of your names, separated into their parts, depending on the parts of the name you chose to split.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/67a54d8724413b0bfdce4854_66070afa642028b5a55d03ed_Results.png)
Custom settings
First, select the column that has the names you'd like to split by selecting it in the Column to Parse dropdown.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/67a54d8724413b0bfdce4851_66070b1e5db4ebc87a9f4eae_Which%2520column%2520Name_.png)
Next, pick the category that you want your full names broken down into by selecting them in the Choose Parts of Name dropdown.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/67a54d8724413b0bfdce485d_66070b4700142bf3549064fe_Total%2520columns.png)
You can select multiple parts in this dropdown, including Salutation, First Name, Middle Name, Last Name, Suffix, and Full Name.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/67a54d8724413b0bfdce4834_66070b7bb2a62d0e5fda3699_Additional%2520columns.png)
If you select a part that does not exist in a name, the row's column will appear blank.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/67a54d8724413b0bfdce485a_66070b9ebe5e4e09f440816c_Middle%2520Name%2520blank.png)
Helpful tips
- Names ending in a comma may not be parsed.
- Names such as "Mister" may be parsed as the salutation, as opposed to the name.