Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) |