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?

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?

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?

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.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=520063