Maximum characters per cell

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

phantom1975 said:

Only 1,024 display in a cell

Click to expand...

Did you test that?

Try this:

Enter the formula
="Z"&REPT(REPT("abcd ",50)&CHAR(10),29)&"Z"

If you just do that, the total viewable characters in the cell is about 1031.

If you align for wrapped text you can now see 7250 or so charcaters.

The effect of Alt+Enter allows for a much greater view of characters in a cell, when the zoom, column width and row height are adjusted.

Thank you guys!