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
Datatab in the toolbar.
Text to Columnsbutton 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 Previewto make sure that the delimiter configuration is correct.
- 7.Click the
Split on delimiterbutton.
A Mito sheet with the Split Text to Columns Taskpane open.