Splitting Cells

[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

 

[Guest]

Try

=A1&"/"&B1

HTH
Steve

 

[Jimmy]

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...

 

[Peo Sjoblom]

Pad it with spaces like this

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

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