Wrap Text problem

[ExcelRon]

I'm having a problem with the Wrap Text function in Excel. I have a good
amount of text that I'm pasting from over to Excel from Word.

Most of my paragraphs are 400 characters or less. Then I have a couple
bigger ones but they're less than 750 characters. In total, I'm trying to
fit (2,944 characters with spaces) into one Excel cell.

I went back and took out all the extra lines, and put them back in with hard
returns (ALT-ENTER).

I've formated the Excel cell to Wrap Text. The first 4 paragraphs are fine,
but then the 5th only shows the first 2 lines, and the remaining paragraphs
only show the first line.

Any ideas around this problem? Thanks.

 

[Susan]

this is text from a posting in exel.programming........

link:
http://groups.google.com/group/micr...character+limit&rnum=1&hl=en#4e76d91957840e18

text:
=====================================

The only question I have now, is that since my "cell" is actually A63:G69
merged as a single cell, it in fact WILL display over the 256 characters I
thought was the limit..........what's up there?.........do I get 256 for
every cell in the merge?

Sorry, I'm not quite following you. I understood that 256 characters
was a limit that YOU wanted to impose for whatever reason. No cell,
whether individual or merged, has an Excel-imposed 256 character
limit. The actual limits are (from "Excel Specifications and Limits"
in the help file), "32,767 characters. Only 1,024 display in a cell;
all 32,767 display in the formula bar." (Disclaimer 1; I once saw a
post from Harlan which used the Rept function and other wizardry to
create an entry in a cell with more characters than that. While it
was
an amusing circus trick and interesting as all get out from a
"pushing
the envelope" point of view, I've yet to see a practical use for such
a cell entry. For most practical purposes, you may regard the limits
as stated in the help file as being "real". Disclaimer 2: Versions of
Excel PRIOR TO Excel 97 apparently DID have a 255 character limit for
the cells. This is mentioned in the "What's new with specifications
and performance" section of the Excel 97 Help file.)

A further limit stated in the help file is that a column width maxes
out at 255 characters BUT that doesn't take into account text
wrapping
as set through the Format Cells dialog; it's just the actual column
width.
===================================
hope this helps!
susan

 

[Susan]

one more thread with more info:

http://groups.google.com/group/micr...character+limit&rnum=5&hl=en#a6a35c03da5248ed

susan