Splitting cells?

Z

Zerex71

I have been wondering the answer to this for a while - can you "split"
a cell like in bowling, golf, etc. if you want to slash-through a
rectanglar cell to make more than one cell holding data? Can this be
done?

Mike
 
R

Roger Govier

Hi

You can give the appearance that you want, but any numeric data entered
would be text and could not be used in any further calculation.

To achieve the appearance,
Format>Cells>Alignment>Wrap Text
Format>Cells>Borders>choose Diagonal
Enter your first number in the cell, press Alt+Enter which will force a
line feed, then enter some spaces followed by your second number.
Experiment with the number of spaces until you see your second number
nicely spaced under the diagonal.
 
Z

Zerex71

Thanks, it worked great!

Regards,
Mike

Roger said:
Hi

You can give the appearance that you want, but any numeric data entered
would be text and could not be used in any further calculation.

To achieve the appearance,
Format>Cells>Alignment>Wrap Text
Format>Cells>Borders>choose Diagonal
Enter your first number in the cell, press Alt+Enter which will force a
line feed, then enter some spaces followed by your second number.
Experiment with the number of spaces until you see your second number
nicely spaced under the diagonal.
Click to expand...
 
B

bgeier

Not that I am aware of, but I wonder if it could be "synthesized" by
using different fonts (superscripts for the 2nd ball in bowling), then
use a formula to parse the data in subsequent cells to do the scoring?
 
Top