Increase the limitation for a Text format cell, now you can enter up to 799 characters in a cell. (In previous version, the limit is only 252 characters)

If you want to enter more, just use the default Text & Numeric format. For a Text & Numeric format cell, you can enter up to 3799 characters.