I have a cell formatted with wrap text. Several columns wide and quite high.
When a large amount of text is entered in the cell, excel will not display
it all. The cell only appears half full. I have tried cell validation with
no success. Is there a limit?

Don

Hi
limit is 1024 characters. You can extend this by manually entering
linebreaks with ALT+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany
"Don" <(E-Mail Removed)> schrieb im Newsbeitrag
news:sXgBd.202528$(E-Mail Removed)...
>I have a cell formatted with wrap text. Several columns wide and quite
>high. When a large amount of text is entered in the cell, excel will not
>display it all. The cell only appears half full. I have tried cell
>validation with no success. Is there a limit?
>
> Don
>

You can have about 32k characters in a cell.

But to see more than about 1000 characters, you have to add some alt-enters to
force new lines within the cell.

You may have to adjust the rowheight manually, too.



Don wrote:
>
> I have a cell formatted with wrap text. Several columns wide and quite high.
> When a large amount of text is entered in the cell, excel will not display
> it all. The cell only appears half full. I have tried cell validation with
> no success. Is there a limit?
>
> Don

--

Dave Peterson

Yes will see only 1024 chars in the cell, but you can input up to 32767
which you can see in the formula bar.

Billy

Thanks.

"Don" <(E-Mail Removed)> wrote in message
news:sXgBd.202528$(E-Mail Removed)...
>I have a cell formatted with wrap text. Several columns wide and quite
>high. When a large amount of text is entered in the cell, excel will not
>display it all. The cell only appears half full. I have tried cell
>validation with no success. Is there a limit?
>
> Don
>