MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Split a cell

Posted by J Ma on November 21, 2000 2:01 PM

Is there any way to split a cell into two parts (kind of oposite of cell merge)? I would like to put
both row title and colum titile into one cell.


Posted by Loren on November 24, 2000 2:57 PM

have you used =left or =mid functions?

Posted by Ivan Moala on November 25, 2000 5:15 AM

Try using the cell format.
Format / Cells - then select Border
Select the diagonal style.
When entering text use Alt + Enter to get your
text aligned with the halves....