Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a limit to the size of a cell containing text in Excel 20
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. |
#2
|
|||
|
|||
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 "Karen" wrote in message ... 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. |
#3
|
|||
|
|||
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. Karen wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Character limit per cell | Excel Discussion (Misc queries) | |||
a way to limit the characters allowed in a cell? | Excel Worksheet Functions | |||
Can I limit a cell to 72 characters? How? | Excel Discussion (Misc queries) | |||
limit worksheet view to specified cell range | Setting up and Configuration of Excel | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |