How to split a cell in Excel?

[Benz_UK]

In word you can right click on a cell in a table and then split it into a
number of cells, without disturbing the surrounding cells of the origininal
cell.
Is there a way of doing the same thing in Excel?

[ewan7279]

Nope. You can merge, but not split.

"Benz_UK" wrote:

> In word you can right click on a cell in a table and then split it into a
> number of cells, without disturbing the surrounding cells of the origininal
> cell.
> Is there a way of doing the same thing in Excel?

[Ted]

That's not true...you can split information in EXCEL apart...
you can Use Text to Columns to split contents of a cell out based on either
fixed length or delimited based on criteria you select such as spaces or
commas.

You can also split information apart using the LEFT, RIGHT functions...
--
Ted


"Benz_UK" wrote:

> In word you can right click on a cell in a table and then split it into a
> number of cells, without disturbing the surrounding cells of the origininal
> cell.
> Is there a way of doing the same thing in Excel?

[wjohnson]

You will need "empty" cells to the left or right of the column you want to split or they will be overwritten when you split, (i.e. if you split 1 column into 3 - you need 3 empty cells.