software

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

quot;Kelly Edwardsquot; gt; wrote in message
...
gt; What is a simple way I can split a cell in Excel? I have read several
posts
gt; regarding this, but they seem above my knowledge of the program. I
already
gt; have a spreadsheet set up and have a few cells that I need to split into 2
to
gt; 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!

quot;Bob Umlasquot; wrote:

gt; Select the cell, use Data/Text to Columns, follow instructions/prompts
gt;
gt; quot;Kelly Edwardsquot; gt; wrote in message
gt; ...
gt; gt; What is a simple way I can split a cell in Excel? I have read several
gt; posts
gt; gt; regarding this, but they seem above my knowledge of the program. I
gt; already
gt; gt; have a spreadsheet set up and have a few cells that I need to split into 2
gt; to
gt; gt; make them line up nicely with what I'm doing. HELP! Thanks!
gt;
gt;
gt;


Click on the cell that you want to split
Click on Data...text to columns
Click on the quot;fixed widthquot; radial
Click next
Click next again
Click Finish--
dkuz
------------------------------------------------------------------------
dkuz's Profile: www.excelforum.com/member.php...oamp;userid=31536
View this thread: www.excelforum.com/showthread...hreadid=512246That 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?

quot;dkuzquot; wrote:

gt;
gt; Click on the cell that you want to split
gt; Click on Data...text to columns
gt; Click on the quot;fixed widthquot; radial
gt; Click next
gt; Click next again
gt; Click Finish
gt;
gt;
gt; --
gt; dkuz
gt; ------------------------------------------------------------------------
gt; dkuz's Profile: www.excelforum.com/member.php...oamp;userid=31536
gt; View this thread: www.excelforum.com/showthread...hreadid=512246
gt;
gt;