Split Columns

Key Features

• Custom separator – Define the exact character or string to split on (e.g., comma, space, dash).
• Selective row start – Choose the row index to begin splitting from (e.g., skip the header row).
• Column targeting – Specify which column to split into two new columns.
• One split, two results – The value is split only on the first occurrence of the separator: the part before goes into one new column, the remainder into another.

How to Use

1. Open the Split Columns dialog.
2. Enter the Start Row (usually 1 to skip the header row).
3. Enter the Column Index you want to split.
4. Specify the Separator character or string (e.g., , or ).
5. Click Apply to create two new columns at the end of the dataset, one for each split part.

Examples

Before

| Name         |
|--------------|
| Alice Smith  |
| Bob Johnson  |

Split on space

| Name         | First | Last    |
|--------------|-------|---------|
| Alice Smith  | Alice | Smith   |
| Bob Johnson  | Bob   | Johnson |

Before

| Location        |
|-----------------|
| Paris, France   |
| Tokyo, Japan    |

Split on comma

| Location      | City  | Country |
|---------------|-------|---------|
| Paris, France | Paris | France  |
| Tokyo, Japan  | Tokyo | Japan   |