Home

RESOLVED - Excel: text in cell being truncated after save

%3CLINGO-SUB%20id%3D%22lingo-sub-355327%22%20slang%3D%22en-US%22%3ERESOLVED%20-%20Excel%3A%20text%20in%20cell%20being%20truncated%20after%20save%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355327%22%20slang%3D%22en-US%22%3E%3CP%3EApparently%20there%20is%20a%20character%20limit%20of%20250%2Fcell%3C%2FP%3E%3CP%3EWorkaround%3A%20if%20you%20need%20more%20verbiage%20requiring%20more%20then%20250%20character%2C%20use%20the%20Text%20Box%2C%20insert%20into%20the%20cell%3C%2FP%3E%3CP%3EI%20did%20not%26nbsp%3Bfind%20a%20setting%20parameter%20to%20increase%20the%20250%2Fcell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWindows%2010%20Enterprise%20%3A%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%26nbsp%3Bof%20my%20text%20(General%20format)%20in%20cells%20is%20being%20truncated%20after%20I%20save%20and%20close%20the%20file.%3C%2FP%3E%3CP%3EThis%20seems%20to%20be%20happening%20only%26nbsp%3Bwith%26nbsp%3Bthe%20last%20column%20of%20the%20worksheet%20cells%3B%20and%20again%2C%20its%20not%20all%20cells%3B%20some%20get%20truncated%20and%20some%20don't.%3C%2FP%3E%3CP%3EI've%20expanded%20the%20window%20size%20of%20the%20cell%26nbsp%3Bto%20make%20sure%20the%20entire%20text%20field%20is%20within%20before%20save.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESaving%20alone%20does%20not%20truncate%3B%20only%20after%20you%20close%20and%20reopen%20does%20this%20issue%20happen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQ%3A%20is%20there%20a%20character%20limit%20on%20each%20cell%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20to%20further%20debug%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-355327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355621%22%20slang%3D%22en-US%22%3ERe%3A%20RESOLVED%20-%20Excel%3A%20text%20in%20cell%20being%20truncated%20after%20save%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355621%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20there%20is%20the%20limit%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FExcel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23ID0EBABAAA%3DNewer_versions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FExcel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%23ID0EBABAAA%3DNewer_versions%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CTABLE%20id%3D%22tblID0EAAEAACBABAAA%22%20class%3D%22banded%20flipColors%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%3E%3CP%20class%3D%22x-hidden-focus%22%3ETotal%20number%20of%20characters%20that%20a%20cell%20can%20contain%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%3E%3CP%20class%3D%22x-hidden-focus%22%3E32%2C767%20characters%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E(about%202%5E16).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20maximum%20number%20of%20displayed%20characters%20is%201024.%20Depends%20on%20version%20and%20cell%20formatting.%3C%2FP%3E%0A%3CP%3EThus%20text%20is%20not%20truncated%2C%20you%20may%20check%20with%20%3DLEN()%2C%20it's%20not%20displayed%20as%20full%20after%20re-opening.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

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.