Cell Dividing
Is there a way that I can divide a cell into two parts. I want a number in
the top portion and a number in the bottom porition of a cell. For instance I have a column of numbers and then a column of names. I want two number in the one cell attached to one name. However I don't just want it to wrap text I want them divided somehow with out creating a whole new column |
Cell Dividing
Hi Jenny, To the best of my knowledge you cannot split cells in Excel - However you can merge two cells on a line above two cells or merge two cells adjacent to two others, which effectively gives you one cell next to two without wrapping. I hope this helps. Kindest regards, Sadie -- Cowgirl ------------------------------------------------------------------------ Cowgirl's Profile: http://www.excelforum.com/member.php...o&userid=37189 View this thread: http://www.excelforum.com/showthread...hreadid=569131 |
Cell Dividing
Jenny
Cannot be done. Gord Dibben MS Excel MVP On Mon, 7 Aug 2006 12:02:09 -0700, Jenny wrote: Is there a way that I can divide a cell into two parts. I want a number in the top portion and a number in the bottom porition of a cell. For instance I have a column of numbers and then a column of names. I want two number in the one cell attached to one name. However I don't just want it to wrap text I want them divided somehow with out creating a whole new column |
All times are GMT +1. The time now is 11:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com