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