Split Text to Columns
This documentation will explain how to use 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.
To Split Text to Columns:
- 1.Select the
Columns
dropdown menu. - 2.Click
Select Text to Columns
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 Mitosheet with the Split Text to Columns Taskpane open, with each step highlighted.
Last modified 1yr ago