Wrapping Text in a cell limitations - Excel 2003

G

Guest

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?
 
T

Tom Ogilvy

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

Casey

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
 
C

Casey

Tom,
Thanks for the additional info. I have used alt>enter 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wrap text in merge cells 7
Wrapping multiline text in merged cells 1
Knowing where text will wrap 3
Find/Replace MSWord wildcard characters from within Excel 6
Excel 2003 get text after wraptext problem 3
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Word wrap and height 1
How can I size merged cells to fit the needed rows of text? 1

Top