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 ...
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.)
