Split cells

**mkinzly** · 07-03-2010, 11:36 AM

Hello, is there a way to split a cell (empty or filled) into 2 or more cells in Excel 2003? Thank you.

**davesexcel** · 07-03-2010, 11:43 AM

Could you supply some more details of what you are looking for?

**royUK** · 07-03-2010, 11:44 AM

If you want to split the contents the Text to Columns from the Data menu. You can't have two or three cells in one column

**mkinzly** · 07-03-2010, 12:19 PM

Ok, I was hoping to convert 1 cell into 2 cells. Similar to merging rows 1 - 4 and 6 -10 of columns D and E, so that row 5 appears to be cells.

**shg** · 07-03-2010, 12:23 PM

You can't divide one cell into two; how would you reference it?

**mkinzly** · 07-03-2010, 12:38 PM

Ok, thank you for the quick replies.

**royUK** · 07-03-2010, 02:05 PM

And I would recommend you don't use Merged Cells at any time,they will cause problems eventually

Re: Split cells (Excel 2003)