Split cells
In the table, click the cell that you want to split. Click the Layout tab. In the Merge group, click Split Cells. In the Split Cells dialog, select the number of columns and rows that you want and then click OK.
Can you split a cell within a cell in Excel?
Unfortunately, you can't do this in Excel. Instead, create a new column next to the column that has the cell you want to split and then split the cell. You can also split the contents of a cell into multiple adjacent cells.
How do you split a cell in Excel formula?
Split Unmerged Cell Using a Formula
- Step 1: Select the cells you want to split into two cells.
- Step 2: On the Data tab, click the Text to Columns option.
- Step 3: In the Convert Text to Columns Wizard, if you want to split the text into the cells based on a comma, space, or other characters, select the Delimited option.
