Is there maximum number of characters per cell?

[Peter Frank]

Hi,

I was trying to enter some lines of text into an Excel cell and
although I could enter it, from a certain point on the cell content is
only displayed as ############################### as soon as I exit the
cell. The cell is formatted as text, and the line break option has been
set.

Is there a maximum number of characters per cell in Excel or why do I
get this? Is there any way I can change this?

Peter

 

[Daniel CHEN]

How many chars do you have in that cell?

Excel limitation:
Column width 255 characters

Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.


For your problem, if your # of chars < 1024, then try:
1) Adjust the column width
2) Wrap text

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================

 

[Dave Peterson]

You can actually see more that 1024 characters by adding alt-enters every 80-100
characters.

 

[Peter Frank]

How many chars do you have in that cell?

Excel limitation:
Column width 255 characters

Length of cell contents (text) 32,767 characters. Only 1,024 display
in a cell; all 32,767 display in the formula bar.

I realized that I can see all characters in the formula bar, but since
it is text I want it to be displayed not only in the formula bar but
directly.

The 1,024 characters/cell display limit seems to be the problem.

For your problem, if your # of chars < 1024, then try:
1) Adjust the column width
2) Wrap text

I did that. Didn't help.

Regards,
Peter

 

[Peter Frank]

You can actually see more that 1024 characters by adding alt-enters every 80-100
characters.

I tried that and I still get ############################ as soon as I
exceed the 1,024 characters/cell display limit. What could I have done
wrong? Are there any special options to be set for this to work?

BTW, I use Excel 2002 (XP).

Peter

 

[Peter Frank]

I tried that and I still get ############################ as soon as I
exceed the 1,024 characters/cell display limit. What could I have done
wrong? Are there any special options to be set for this to work?

BTW, I use Excel 2002 (XP).

Problem is solved now. What I did wrong was that I still had formatted
the cell as "Text" (under "Category"). When I changed that cell format
to "General", your method worked. So, thanks for the tip.

Peter