Text is cutoff in a cell

[Guest]

I have a large amount of text in a merged, wrapped cell. It is about 25
lines long, but only the first 12 are showing. I have tried to enlarge the
height of the cell, but then it just shows black space, not the rest of the
text. How would I fix this.

 

[Guest]

Excel will accepts 32,000+ characters in a cell, but it limits the display to
1,024 characters. My guess is that you've maxed out the display limit.

If you have MS Word you can copy the text into a Word document and then do a
word count, you'll also get a count of characters along with the word count
total.

 

[Guest]

That would explain it. Thank you!

Excel will accepts 32,000+ characters in a cell, but it limits the display to
1,024 characters. My guess is that you've maxed out the display limit.

If you have MS Word you can copy the text into a Word document and then do a
word count, you'll also get a count of characters along with the word count
total.

 

[Dave Peterson]

You can see lots more than those approximately 1000 characters if you add
alt-enters every 80-100 characters.

 

[Guest]

WOW! At first I thought you were crazy but I just tried alt-enter and it
works perfectly! Thank you so much for sharing. It's always good to learn
something new.
Steph

 

[Dave Peterson]

Just because it worked doesn't necessarily eliminate the possibility that I'm
crazy!!!!!!

Both things could be true!

<vbg>