Splitting Cells

  • Thread starter Thread starter jimmy
  • Start date Start date
J

jimmy

I have two sets of data that i want to represent in the
same cell. Is there anyway i can create a diagonal line
through the cell and have the first set of data appear
above the diagonal line and the other set below the line?

for example:

X/Y

1/2
2/3
4/5

something like that, but the diagonal line goes through
the entire cell?

THANKS A LOT
 
I had previously tried that, but i do not want it to have
the slash look like that. What i wanted to do was have a
diagonal line that started at the bottom left corner of
the cell and went to the top right corner of the cell, so
as to kinda create to triangles within a cell. Thanks
again for the help...
 
Pad it with spaces like this

=A1&" "&B1 (adapt to fit the cell size)

then do format>cell>border and use a diagonal border
 
Back
Top