Split Text to Columns

Split a column into multiple based on a delimiter.

Why Split Text to Columns

Splitting text to columns takes the text in one column and splits it into multiple columns based on a delimiter. It is especially useful when one cell contains multiple pieces of information that you would like to operate on separately.

How to Split Text to Columns

To Split Text to Columns:

  1. Select the Data tab in the toolbar.

  2. Click Text to Columns button to open the taskpane.

  3. Select the dataframe that contains the column you want to split.

  4. Select the column you want to split.

  5. Select the delimiters that you want to use as breakpoints within each cell.

  6. Use the Columns Preview to make sure that the delimiter configuration is correct.

  7. Click the Split on delimiter button.

Last updated