Dispay two values in one cell with the / border separating them.

[Guest]

Is there a way to display two values in one cell with the / border separating
them?

 

[Harlan Grove]

Is there a way to display two values in one cell with the / border
separating them?

Only in the sense of

="one thing"&" / "&"and another"

No other way to do it since Excel only supports _one_ value per cell,
so the closest you'll ever get is one text value possibly showing
multiple other values.

Or you could store one value in, say X99 and the other in Y100 and
draw a diagonal line from the bottom-left corner of X100 to the top-
right corner of Y99.

 

[Gord Dibben]

Format the cell with the diagonal border and outline border.

Using spaces, pad the cell contents until you get the look you want.


Gord Dibben MS Excel MVP