Wrapping Text in a cell limitations - Excel 2003
 

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?

Wrapping Text in a cell limitations - Excel 2003
 

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

--
Regards,
Tom Ogilvy

"FLHOIT" wrote in message
...
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?

Wrapping Text in a cell limitations - Excel 2003
 

FLHOIT,
If you type in "Excel specifications and limits" into help and look fo
"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 i
a cell; all 32,767 display in the formula bar.

HT

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=47763

Wrapping Text in a cell limitations - Excel 2003
 

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

--
Regards,
Tom Ogilvy


"Casey" wrote in
message ...

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

Wrapping Text in a cell limitations - Excel 2003
 

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

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=47763