A cell can contain about 32k characters--but only about 1000 characters will be
visible in the cell (unless you add some alt-enters every 80-100 characters.

One way to put all those cells into one cell (but all the characters won't be
viewable):

Put this in B1:
=a1

Put this in B2:
=b1&","&A2
and drag down the column.

select that last cell and
edit|copy
edit|Paste special|values

And you can clear the cells B1:b299.

==========
If you want to see all the numbers in that last cell, you could add the
alt-enters (char(10)'s) every so often.

In B1:
=A1
(no change)

In B2:
=B1&","&IF(MOD(ROW(),7)=0,CHAR(10),"")&A2
And drag down

Convert to values and clean up those other cells.

And format that cell nicely.
Widen the column
format|cells|alignment tab|check Wrap Text
Deepen the row height if you have to.



Bob Newman wrote:

This is a request for a friend. He has a long list on numbers (usually 10
digits) in a column. Let's say A1:A300. Is there a formula that will enter
all of those numbers into one cell consecutively separated by commas and no
spaces? I guess the question also begs the question of how much information
you can place in one cell. I am unsure of the Excel version although I am
sure it is a late one if not 2003.

Thanks in advance... Bob

--

Dave Peterson