Comment on page
Split Text to Columns
Split a column into multiple based on a delimiter.
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.
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.

A Mito sheet with the Split Text to Columns Taskpane open.
Last modified 9d ago