Wrapping Text in a cell limitations - Excel 2003

[FLHOIT]

When wrapping text in a cell (Excel 2003), does the wrapping only apply to a
limited amount of characters? I notice the wrapping stops after a certain
point. Is there a work around?

[Casey]

FLHOIT,
If you type in "Excel specifications and limits" into help and look for "Length of cell contents" you might see where your problem is at.
For my version 2002 it reads:
Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

HTH

[Tom Ogilvy]

It stops around 1024 characters. You can overcome it by doing Alt+Enter
periodically within the data.

--
Regards,
Tom Ogilvy

"FLHOIT" <adam.lehmann@myfloridahouse.gov> wrote in message
news:43325056-6735-4A88-B074-B801A1712857@microsoft.com...
> When wrapping text in a cell (Excel 2003), does the wrapping only apply to
a
> limited amount of characters? I notice the wrapping stops after a certain
> point. Is there a work around?
>

[Tom Ogilvy]

That's true, but if you use what I posted, you can exceed 1024.

--
Regards,
Tom Ogilvy


"Casey" <Casey.1x60ug_1129752319.3226@excelforum-nospam.com> wrote in
message news:Casey.1x60ug_1129752319.3226@excelforum-nospam.com...
>
> FLHOIT,
> If you type in "Excel specifications and limits" into help and look for
> "Length of cell contents" you might see where your problem is at.
> For my version 2002 it reads:
> Length of cell contents (text) 32,767 characters. Only 1,024 display in
> a cell; all 32,767 display in the formula bar.
>
> HTH
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile:
http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=477635
>

[Casey]

Tom,
Thanks for the additional info. I have used alt>enter alot for formatting reasons, I did not know you could circumvent the 1024 limit by using it. I occasionally need that many characters in cell and always ended up splitting the information between cells.