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
=================================



"Peter Frank" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Dave Peterson]

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


Daniel CHEN wrote:
>
> 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
> =================================
>
> "Peter Frank" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >

--

Dave Peterson

[Peter Frank]

Daniel CHEN wrote:

> 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]

Dave Peterson wrote:

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

> Dave Peterson wrote:
>
> > 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).

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