ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can one cell contain more than one independent number (https://www.excelbanter.com/excel-discussion-misc-queries/33385-can-one-cell-contain-more-than-one-independent-number.html)

John K

can one cell contain more than one independent number
 


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:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


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


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com