Text is cutoff in a cell

J

Jessica

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.
 
K

Kevin B

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.
 
J

Jessica

That would explain it. Thank you!

Kevin B said:
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.
Click to expand...
 
D

Dave Peterson

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

Stephanie Nicolosi

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
 
D

Dave Peterson

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

Both things could be true!

<vbg>
 
Top