Total Cell Characters Count

[unekme]

My boss has typed a large amount in an excel cell and it will not show all
that he has typed. I have searched and can not find how many characters are
allowed in each cell and if there is a way to allow all the characters to
show in the cell.

 

[Dave Peterson]

Excel will show about 1000 characters in cell unless you do something special.

Add alt-enters (to force new lines within the cell) every 80-100 characters to
see more.

If you try this and see #######'s, make sure the cell is formatted as General
(not Text).

You can see how long the string is with a formula like:
=len(a1)

You can see the limits and specifications that excel has by searching Excel's
help for Specifications.

(but you won't see this alt-enter technique.)