Forum Discussion
RESOLVED - Excel: text in cell being truncated after save
Apparently there is a character limit of 250/cell
Workaround: if you need more verbiage requiring more then 250 character, use the Text Box, insert into the cell
I did not find a setting parameter to increase the 250/cell
Windows 10 Enterprise : Excel
Some of my text (General format) in cells is being truncated after I save and close the file.
This seems to be happening only with the last column of the worksheet cells; and again, its not all cells; some get truncated and some don't.
I've expanded the window size of the cell to make sure the entire text field is within before save.
Saving alone does not truncate; only after you close and reopen does this issue happen.
Q: is there a character limit on each cell?
Any suggestions to further debug this?
3 Replies
I found a limitation on the number of characters in the header row of tables - it is limited to 255 characters and it just truncates the data after the 255th character. It does not seem related to Saving, it truncates when moving to the next cell or hitting Enter. It does not matter if they are formatted as General or Text.
Yes, there is the limit https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?ui=en-US&rs=en-US&ad=US#ID0EBABAAA=Newer_versions
Total number of characters that a cell can contain
32,767 characters
(about 2^16).
However, maximum number of displayed characters is 1024. Depends on version and cell formatting.
Thus text is not truncated, you may check with =LEN(), it's not displayed as full after re-opening.
- Hmm, unsure I've followed the above solution. I have Some text boxes which are populating from specific cells. I can see all text in the original cell. Lets say A1. I have =$A$1 as the formula in the text box, but the text is still truncated in the text box. (Text is about same length as these comments, and is being cut about 2 thirds of the way through.)
