Hi, I have a predefined locked down sheet, that users are
filling in with some detailed information. It appears to
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 ?

Any assistance much appreciated !

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

Neil,
I just got 10K chars in a cell as reported by LEN.

NickHK

"Neil" wrote in message
...
Hi, I have a predefined locked down sheet, that users are
filling in with some detailed information. It appears to
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 ?

Any assistance much appreciated !

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


.

Hi
in the cell it shows only the first 1024 though in the formular bar
you'll see all characters (up to 32.767). Search the Excel helpfile for
'Specification' to get more information about this

--
Regards
Frank Kabel
Frankfurt, Germany

Neil wrote:
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


.

To see more than 1024 (or whatever extra characters to reach the right side
of the cell), you need to put in hard carriage returns (alt+enter)

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
in the cell it shows only the first 1024 though in the formular bar
you'll see all characters (up to 32.767). Search the Excel helpfile for
'Specification' to get more information about this

--
Regards
Frank Kabel
Frankfurt, Germany

Neil wrote:
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


.