Alt-enters at the bottom helping? I wouldn't guess so, but what happened when
you tried it?

How about a hyperlink to an MSWord file where things are formatted nicer?

Rachael wrote:

I have already done that after each paragraph, which is usually only 1-2
sentences each (some are a little longer, 4 or 5). Due to the nature of the
text, I can't break it up anymore than what it is. Each cell has the text of
a letter (ie cover letter) put into opening paragraph, middle paragraphs, and
ending paragraph. The formating must remain as is, and if I add extra spaces
it will not look professional.

Would adding an Alt-Enter or two at the end of the data help?

"Dave Peterson" wrote:

Add some alt-enters (to force new lines within the cell) every 80-100
characters. And you'll be able to see more than those 1000 characters or so.

Rachael wrote:

I have a spreadsheet where I am entering several small paragraphs of text
into one cell (less than 2000 characters) in a chart, and there are more than
80 cells where I need to enter similar data (3 to 8 paragraphs per cell).

Excel only seems to recognise the first 1000 or so characters (with spaces)
when I copy data into or out of the cell (from word to the cell and from the
cell back to word) so some of my data is getting cut off. Also, when I do the
"auto fit height" it also ignores any data after approx 1000 characters, so
my data is not in view. If I re-size it and can see the data, save it, and
re-open it, the data is all cut off again. Why is this? Anyway to fix it
(please say yes!!)

I have tried 3 versions of excel (97, 2000, 2003) and all do the same thing.

--

Dave Peterson


--

Dave Peterson