Cell Capacity

[KenP]

Hi, I hope you are having a great day.

I exported a query/report from Access 2000 into Excel.
Everything looked okay until I examined it further and
found the data in one of the cells was truncated. I tried
everything I could think of to get the info, but nothing
worked. Without counting the characters, it appears the
truncate position is the same in all cells.

Does anyone have a solution for this other than retyping
the truncated data into Excel.

Thanks in advance.
KP

 

[Otto Moehrbach]

KP
Look in Help under Specifications. Excel can hold some 30,000+
characters in one cell but it will display only some 1000+ of them. All the
characters will be visible in the formula bar though. If you want all the
characters to be visible in the cells, you will have to enter some of them
into another cell. You can do this by cutting/pasting from the formula bar.
Post back if you need more help with this. HTH Otto

 

[Dave Peterson]

Actually, if you add a few alt-enters into the text, you can see lots more than
the 1000 character limit described in the Excel's help.

 

[Dave Peterson]

If you use a formula:

=len(a1)

(point at good cell, though)

Do you get 255? I don't use Access, but if I try to retrieve more than 255
characters from a cell in a closed workbook, it gets truncated at 255.

My workaround (for closed xl to xl) is to split my text into multiple cells. I
don't know if that's possible/feasible for you in Access.

 

[Dave Peterson]

And just to make clear, I split the long cells in the original workbook.