1160 Max Chars per cell ? Workaround ?

N

Neil

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 !
 
A

arno

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 ?
Click to expand...

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
 
N

Neil

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 ?
 
F

Frank Kabel

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
 
T

Tom Ogilvy

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)
 
Top