Hi,

I am exporting a file to excel and running into errors. I have determined
that it is one particular field that I am exporting that is causing the
trouble. Is there a limit on characters that a single excel cell can
contain, and is this different for exported files, and are there some
characters that excel cell's done like, or would cause trouble?

Thanks

Spencer-

Here are the cell size specifications found in Excel Help under "Excel
Specifications and Limits":

Length of cell contents (text) - 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.

Why Excel is designed to allow 32K characters to be stored in a cell but
only display 1024 on a worksheet is a mystery to me. The only way to see all
of a string longer than 1024 characters in the the formula bar.

-Stan Shoemaker
Palo Alto, CA


"Spencer23" wrote:

Hi,

I am exporting a file to excel and running into errors. I have determined
that it is one particular field that I am exporting that is causing the
trouble. Is there a limit on characters that a single excel cell can
contain, and is this different for exported files, and are there some
characters that excel cell's done like, or would cause trouble?

Thanks