Split a cell - Microsoft Support (2024)

You might want to split a cell into two smaller cells within a single column. 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.

See the following screenshots for an example:

Split the content from one cell into two or more cells

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.

2. Go toData > Data Tools > Text to Columns.Text to Columns opens.

3. Select the delimiter or delimiters to define the places where you want to split the cell content, and then selectApply.

See Also

Merge and unmerge cells

Merging and splitting cells or data