Split Cells Diagonally into TWO Cells

[shapeshiftingkiwi]

Is there any way to change cell shape so that in the below example, the top left section of C1 stays C1 and the bottom right section of C1 turns into its own cell D1? I am not looking to just split the cell with a border as show here. I want each triangle to be its own fully editable cell. The only things I can find are splitting the cells and then painstakingly moving around the text to fit. I'm guessing there's no way to do this, I don't know what the column header would even look like.

 

[Jimmypop]

Hi there

I do not think what you want to do is possible. The only way I can think of is if you use borders. One cannot split a cell into two...

 

[vladimiratanasiu]

Is there any way to change cell shape so that in the below example, the top left section of C1 stays C1 and the bottom right section of C1 turns into its own cell D1? I am not looking to just split the cell with a border as show here. I want each triangle to be its own fully editable cell. The only things I can find are splitting the cells and then painstakingly moving around the text to fit. I'm guessing there's no way to do this, I don't know what the column header would even look like.

View attachment 80866

There is no specific formula, to do this request. You could combine the content of the two cells, adjusting then within formula the space between their content so that it will match the borders.

Book3
	A	B
2	1111	2222
3	1111 2222
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A2&" "&B2

 

[shapeshiftingkiwi]

Huh, how did you get the diagonal to bisect the side of the cell like that?

 

[Sufiyan97]

Format cells > Border

 

[vladimiratanasiu]

Huh, how did you get the diagonal to bisect the side of the cell like that?

How to create cell border in Excel

See how to insert border in Excel by using the predefined options and create your custom cell border style.

www.ablebits.com

 

[vladimiratanasiu]

And as I said, adjusting the lenghth of space from formula, so that values will fit the cell borders.

 

[shapeshiftingkiwi]

Ohh I see, there's two rows in your example not one. I thought it was split differently. OK that's probably the closest thing to a solution.