can one cell contain more than one independent number

  • Thread starter Debra Dalgleish
  • Start date
D

Debra Dalgleish

A cell can contain several numbers, separated by space characters or
line breaks (Alt+Enter).

However, if you want to perform calculations on the numbers, it's best
to keep them in separate cells.

John K wrote:
 
A

abcd

there's also the option a using matrix formula (list of data)
for example you may enter ={1;2;3} in a single cell or selection 'and
validate wih CTRL+SHIFT+ENTER
but the manipulation of this kinda of formula need to read more about
it...
 
Top