> ## Documentation Index
> Fetch the complete documentation index at: https://parabola.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/yElMlrQLzUnRnyYT/images/columns/split-names-input.png?fit=max&auto=format&n=yElMlrQLzUnRnyYT&q=85&s=a7d1d417710f5c743af19d126e8772f1" alt="Input table with a single column of full names" width="1410" height="1240" data-path="images/columns/split-names-input.png" />
</Frame>

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.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/yElMlrQLzUnRnyYT/images/columns/split-names-output.png?fit=max&auto=format&n=yElMlrQLzUnRnyYT&q=85&s=d02b4549a79d48cc7591198ac37754eb" alt="Output table with new columns for first name, last name, and other selected name parts" width="1880" height="1228" data-path="images/columns/split-names-output.png" />
</Frame>

## Custom settings

First, select the column that has the names you'd like to split by selecting it in the **Column to Parse** dropdown.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/yElMlrQLzUnRnyYT/images/columns/split-names-custom-settings-1.png?fit=max&auto=format&n=yElMlrQLzUnRnyYT&q=85&s=116e5f80d017757f41d6f265fe1fae45" alt="Column to Parse dropdown selecting the source column of full names" width="1888" height="1222" data-path="images/columns/split-names-custom-settings-1.png" />
</Frame>

Next, pick the category that you want your full names broken down into by selecting them in the **Choose Parts of Name** dropdown.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/yElMlrQLzUnRnyYT/images/columns/split-names-custom-settings-2.png?fit=max&auto=format&n=yElMlrQLzUnRnyYT&q=85&s=a0296a5b590e36b4aaec1e102136d01f" alt="Choose Parts of Name dropdown for selecting which name components to extract" width="1897" height="1223" data-path="images/columns/split-names-custom-settings-2.png" />
</Frame>

You can select multiple parts in this dropdown, including *Salutation*, *First Name*, *Middle Name*, *Last Name*, *Suffix*, and *Full Name*.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/yElMlrQLzUnRnyYT/images/columns/split-names-custom-settings-3.png?fit=max&auto=format&n=yElMlrQLzUnRnyYT&q=85&s=ba9fdfbe10d2ca3f717c1c28b60d7518" alt="Multiple name parts selected including Salutation, First Name, Middle Name, Last Name, and Suffix" width="1886" height="1218" data-path="images/columns/split-names-custom-settings-3.png" />
</Frame>

If you select a part that does not exist in a name, the row's column will appear blank.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/yElMlrQLzUnRnyYT/images/columns/split-names-custom-settings-4.png?fit=max&auto=format&n=yElMlrQLzUnRnyYT&q=85&s=6b67c8a1686121bcca76f503c58d8861" alt="Output where rows missing a particular name part show a blank in that new column" width="1885" height="1230" data-path="images/columns/split-names-custom-settings-4.png" />
</Frame>

## 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.

## Related steps

* [Split column](/product/transform/split-column) — split arbitrary delimited columns when names aren't involved.
* [Combine columns](/product/transform/combine-columns) — reassemble first, middle, and last name parts into a single field.
* [Change text casing](/product/transform/change-text-casing) — normalize the casing of name parts after splitting.
* [Find and replace](/product/transform/find-and-replace) — clean up unusual characters before parsing names.
* [Clean data](/product/transform/clean-data) — strip whitespace and standardize name formatting.
