Can you split a cell in Excel 2010 the way a cell is split in Word 2010

Thank you for answering the question asked!   I, too, wanted to do exactly what Yaminah wanted to do, and only kept finding the information about splitting data into already-existing columns.

Anyone happen to know WHY you can merge and unmerge but cannot split an unmerged cell into multiple cells? I need this option frequently...

No.  You can merge cells but not split cells unless they are merged cells.

Just copy all your Excel sheet,

Paste it into Word,

In Word split the cells you need

Copy and Past it back into Excel.

Formulas and some formatting will however be lost

Why would you possibly need more [cells]?

I think the issue is not that more cells are needed, but rather that we want to do something that only takes one step in Word but requires multiple steps (plus a little thinking ahead) in Excel.

To do this in Excel, you have to insert an empty column, then merge the header cells and other nonsplit cells, and then resize the column widths back to fit the original width. 

I was hoping that a shortcut existed, but I guess it doesn't...  maybe because Excel wouldn't know where to insert a split if it has never been split before (ie. unmerged)?  Word is a very layout/visually oriented program, so it keeps track of where the mouse is relative to content, but Excel is not made that way?

This is all guessing, so please correct me if I'm wrong.

Thanks!

You can use DATA / DATA TOOLS / TEXT TO COLUMNS. It will split cell (or columns) contents into several cells.

It will not insert columns, though, so it might overwrite data in cells to the right of the one you are splitting, so make sure to insert cells in advance.