Max characters in cell - workaround?

  • Thread starter Thread starter Tobias Johansson
  • Start date Start date
T

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
 
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
 
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
Click to expand...
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!
 
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
 
Actually, you can see more than 1024 characters. If you pepper your text with a
few alt-enters, then you can see more.
 
Thank you, changing from text to general solved the problem.
Regards,
Tobbe Gårdner
 
Back
Top