Question

how to split cells in excel

Answer 1

Select the cell or cells whose contents you want to split.

Important:  When you split the contents, they will overwrite the contents in the next cell to the right, so make sure to have empty space there.

On the Data tab, in the Data Tools group, click Text to Columns. The Convert Text to Columns Wizard opens.

Choose Delimited if it is not already selected, and then click Next.

Select the delimiter or delimiters to define the places where you want to split the cell content. The Data preview section shows you what your content would look like. Click Next.

In the Column data format area, select the data format for the new columns. By default, the columns have the same data format as the original cell. Click Finish.

Answer 2

Splitting cells:

1) Click on the cell you want to multiple/split.

2) Click on Layout tab.

3) Click on Split cells option.

4) The split cells dialog box appears.

5) Choose the number of rows and columns you want to split.

6) Finally, click on OK option.

NOTE:

1) You can find Split cells option in the Merge group.

2) We use Split cells option to divide a cell into many cells.