Actually, since xl97, a cell can contain 32767 characters.

Excel's help documents that only 1024 will display in the cell. But that isn't
true. You can add lots of alt-enters to force new lines in the cell (every
80-100 characters or so) and you can see lots more.



Alok wrote:

Hello ConfusedAccessUser,

How do you figure that Excel is truncating the data. If it is because you
cannot see the enitire data in a cell then that is only because cells can
contain larger amount of data than they can display. I think they can display
upto 512 characters but can contain more.

Alok Joshi

"Confused access user" wrote:

When I port my data from access to excel the data truncates. In access the I
use a text box with the can grow setting. I have verifed that the data is
stored in the excess table. When I port it to excel using the report
feature, my data is truncated.

--

Dave Peterson