How to split a cell in Excel?

B

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?
 
T

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...
 
W

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.
 
Top