How to covert text into columns
To convert text into columns
- Select the cell range that has the text you wish to convert into columns.
- Go to Data > Text to Columns
.
- Choose the delimiters, such as comma, space, or tab, that you want to use to split the text into columns.
- Set the destination for the output.
- Preview and click Create.