Dividing cells

black eyed dog · May 16th, 2002, 05:44 AM

Can you divide a cell into two and be able to enter data into each half?

dog

dimrod · May 16th, 2002, 05:49 AM

I think this is a wonderful question.

Please explain more about what you are trying to do.

black eyed dog · May 16th, 2002, 05:56 AM

I just want to have a diagonal line running through each cell so I can put a number above and below the line.

WayneTN · May 16th, 2002, 07:03 AM

Black Eyed Dog,

Don't know exactly what your final needs are, but one miserable way to do this would be to take 4 cells in a rectangle (2 x 2), use a white fill color to get rid of the grid lines, and then draw a diagonal line from corner-to-corner across the rectangular "cell". You could even zoom to about 50 - 75% to make the "cell" size more realistic. Once you get that set up, you could enter data above and below the diagonal line. Like I said, it ain't pretty! but would work as far as it goes....

crimlet · May 16th, 2002, 07:11 AM

It depends how many cells you want like that. You could use the merge cell option, then un merge the cells you want to be able to put text into

dimrod · May 16th, 2002, 07:20 AM

Another miserable way is to format the cell with a diagonal and with centre alignment.

Then input(as one input) the first number, as many spaces to fit the numbers appropriately into the cell, and the second number.

I think I've seen this done in a more sophisticated way but can't recall where (perhaps I dreamt it). Can't think how to do it better at present. Damn! More lost sleep!

Joe Was · May 16th, 2002, 07:21 AM

If the first value is in cell "A1" and the second value is in cell "B1" and you want the result displayed in cell "C1." Then put this formula in cell "C1:"

=A1 & "/" & B1

If A1= Test1 and B1= Test2 then the result in C1 will be Test1/Test2. Hope this helps.

Joe Was · May 16th, 2002, 07:32 AM

As a pseudo format, use three adjacent cells in one row. The first cell is formatted with the cell-alignment-vertical set to "Top." The middle cell set to center with a font size double that of the first or last cell and put a date-slash ("/") in it. The last cell is set to bottom and its font is normal. Then adjust the column width to match the slash placement. Hope this helps. JSW

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 05:44 AM	#1
black eyed dog New Member Join Date: May 2002 Posts: 5	Can you divide a cell into two and be able to enter data into each half? dog

May 16th, 2002, 05:49 AM	#2
dimrod Join Date: May 2002 Posts: 73	I think this is a wonderful question. Please explain more about what you are trying to do.

May 16th, 2002, 05:56 AM	#3
black eyed dog New Member Join Date: May 2002 Posts: 5	I just want to have a diagonal line running through each cell so I can put a number above and below the line.

May 16th, 2002, 07:03 AM	#4
WayneTN Board Regular Join Date: May 2002 Location: Tennessee, USA Posts: 72	Black Eyed Dog, Don't know exactly what your final needs are, but one miserable way to do this would be to take 4 cells in a rectangle (2 x 2), use a white fill color to get rid of the grid lines, and then draw a diagonal line from corner-to-corner across the rectangular "cell". You could even zoom to about 50 - 75% to make the "cell" size more realistic. Once you get that set up, you could enter data above and below the diagonal line. Like I said, it ain't pretty! but would work as far as it goes....

May 16th, 2002, 07:11 AM	#5
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	It depends how many cells you want like that. You could use the merge cell option, then un merge the cells you want to be able to put text into

May 16th, 2002, 07:20 AM	#6
dimrod Join Date: May 2002 Posts: 73	Another miserable way is to format the cell with a diagonal and with centre alignment. Then input(as one input) the first number, as many spaces to fit the numbers appropriately into the cell, and the second number. I think I've seen this done in a more sophisticated way but can't recall where (perhaps I dreamt it). Can't think how to do it better at present. Damn! More lost sleep!

May 16th, 2002, 07:21 AM	#7
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	If the first value is in cell "A1" and the second value is in cell "B1" and you want the result displayed in cell "C1." Then put this formula in cell "C1:" =A1 & "/" & B1 If A1= Test1 and B1= Test2 then the result in C1 will be Test1/Test2. Hope this helps.

May 16th, 2002, 07:32 AM	#8
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	As a pseudo format, use three adjacent cells in one row. The first cell is formatted with the cell-alignment-vertical set to "Top." The middle cell set to center with a font size double that of the first or last cell and put a date-slash ("/") in it. The last cell is set to bottom and its font is normal. Then adjust the column width to match the slash placement. Hope this helps. JSW