I should have stated that I can get greater than 1160
chars in a cell, but it wont display them, it only shows
the first 1160 ?


-----Original Message-----
Hi Neil,

me that each cell or merged cell has a char limit of
1160, is this correct ? if so what workarounds are
there
if any ? I tried simply formatting as text but that had
no effect ?

how do you get the text into the cells? Usually, text of
this size should be
in memo-fields in a database and not in Excel.

When I use formulas that concatenate text I can have up
to 32.767 characters
as text in a cell (which is an sql-statement in my
case). It's less when I
copy a sheet, import data via ADO and sql, formulas can
be up to approx.
1000.

arno


.