Is there a limit to the size of a cell containing text in Excel 20

G

Guest

I have a cell that contains a large quantity of text. It wraps correctly for
most of the cell, but then stops wrapping the text correctly after approx
1000 characters. This happens in more than one cell in the worksheet. As an
experiment I copied and pasted the cell into Word. The text is complete and
wrapped correctly in a word table cell.

I have suggested my client in the interim copy and paste the text into Word,
but they would prefer to just use Excel. Is this a limitation of Excel? Or
is this something I can fix.
 
P

Paul B

Karen, from help the limit in excel is, cell content 32,767 characters. Only
1,024 display in a cell; all 32,767 display in the formula bar. for more
information see Excel specifications and limits in help.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
D

Dave Peterson

If you add a few alt-enters (to force a new line within the cell) every 80-100
characters, you'll be able to see lots more than the documented 1024 characters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top