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!

Select the cell, use Data/Text to Columns, follow instructions/prompts

"Kelly Edwards" wrote in message
...
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!

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!

"Bob Umlas" wrote:

Select the cell, use Data/Text to Columns, follow instructions/prompts

"Kelly Edwards" wrote in message
...
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!

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


--
dkuz
------------------------------------------------------------------------
dkuz's Profile: http://www.excelforum.com/member.php...o&userid=31536
View this thread: http://www.excelforum.com/showthread...hreadid=512246

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?

"dkuz" wrote:


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


--
dkuz
------------------------------------------------------------------------
dkuz's Profile: http://www.excelforum.com/member.php...o&userid=31536
View this thread: http://www.excelforum.com/showthread...hreadid=512246