Text is cutoff in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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...
 
You can see lots more than those approximately 1000 characters if you add
alt-enters every 80-100 characters.
 
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
 
Just because it worked doesn't necessarily eliminate the possibility that I'm
crazy!!!!!!

Both things could be true!

<vbg>
 
Back
Top