Max characters in cell - workaround?

[Tobias Johansson]

Hi,
There is some kind of limit in the number of characters that is possible to
put in a cell. When going over that limit, only hashes "####" are displayed
in the cell. Anyone who know a workaround to this problem?

Best regards,
Tobias Gårdner

 

[WillR]

Maximum length of cell contents (text) 32,767 characters.

Maximum of 1,024 chars can be displayed in a cell;

all 32,767 display in the formula bar.


So, no matter how big you make your cell, you'll only ever displa
1,024 characters

Wil

 

[John Thow]

Maximum length of cell contents (text) 32,767 characters.

Maximum of 1,024 chars can be displayed in a cell;

all 32,767 display in the formula bar.


So, no matter how big you make your cell, you'll only ever display
1,024 characters

Will

If you haven't got that many characters in the cell, Format; Column; Autofit
selection will let you see what's there.
--
John Thow
an optimist is a guy/ that has never had/ much experience -
certain maxims of archie; Don Marquis.

To e-mail me, replace the DOTs in the Reply-To: address with dots!

 

[Gord Dibben]

Tobias

You have a couple of other suggestions. Here's another one.

You may have the cell formatted as Text. Excel prefers General for some
reason. Try that.

Gord Dibben XL2002

 

[Dave Peterson]

Actually, you can see more than 1024 characters. If you pepper your text with a
few alt-enters, then you can see more.

 

[Tobias Johansson]

Thank you, changing from text to general solved the problem.
Regards,
Tobbe Gårdner