splitting a cell in Excel

K

Kelly Edwards

What is a simple way I can split a cell in Excel? I have read several posts
regarding this, but they seem above my knowledge of the program. I already
have a spreadsheet set up and have a few cells that I need to split into 2 to
make them line up nicely with what I'm doing. HELP! Thanks!
 
K

Kelly Edwards

This does not work because I can't get it to split it into two cells. It
leaves it as one cell and only retains the data to the left. HELP!
 
D

dkuz

Click on the cell that you want to split
Click on Data...text to columns
Click on the "fixed width" radial
Click next
Click next again
Click Finish
 
K

Kelly Edwards

That doesn't do what I want. That moves the data into adjoining columns. I
want there to be two cells under the same column. For example, say I want to
split cell B11 into two cells...I want there to be like a B11a and a B11b
rather than sending part of the data over to C11 because I already have data
there that I can't move. Does that make sense? Is that even a possibility?
 
Top