Home

RESOLVED - Excel: text in cell being truncated after save

wtmd
New Contributor

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?

 

1 Reply

Yes, there is the limit https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269...

 

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.

Related Conversations
Problems with formating text within a cell.
Maciej Fox in Excel on
10 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Giant stupid numbers
Headaking in Excel on
4 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies