Text is cutoff in a cell
 

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.

Text is cutoff in a cell
 

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.
--
Kevin Backmann


"Jessica" wrote:

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.

Text is cutoff in a cell
 

That would explain it. Thank you!

"Kevin B" wrote:

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.
--
Kevin Backmann


"Jessica" wrote:

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.

Text is cutoff in a cell
 

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



Jessica wrote:

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.

--

Dave Peterson

Text is cutoff in a cell
 

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" wrote:

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



Jessica wrote:

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.

--

Dave Peterson

Text is cutoff in a cell
 

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

Both things could be true!

<vbg

Stephanie Nicolosi wrote:

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" wrote:

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



Jessica wrote:

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.

--

Dave Peterson


--

Dave Peterson