I want to split data that is contained in a single cell into multiple columns in my Excel worksheet. What is the process for splitting data into columns in Excel?
Vishalini.R Answered question April 19, 2023
In the table, click the cell that you want to split. On the ribbon, select the Layout tab. Select Split Cells. In the Split Cells dialog, select the number of columns and rows that you want and then click OK.
Sandhya Answered question April 19, 2023