Software

Ask something
Discussion Locked

32,000 characters in Excel 97/2000 cell

0 helpful
8 replies

by brucelloyd1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When Excel 97 was introduced in Jan 1997, one of the big enhancements was the number of characters that each cell could contain. It changed from 256 to 32,000. However, I've never been able to get more than about 1024 characters in a cell. Same limit encountered in Excel 2000. Will this be fixed in Office 10?

8 replies

by dklippert

Works for me. in all 3 versions.
Try putting =REPT("A",32767) in A1, then check it using
=LEN(A1).

by brucelloyd1

Although your formula works OK, it doesn't address my problem. Try typing text with spaces in a cell. It appears ok in edit mode. However, it doesn't display in Ready mode at the end of the string near column DH. Sometimes changing colum widths helps display some missing text.

by dklippert

Sorry, cells can "contain" 32,767 characters.
However only 1024 will be "displayed" in a cell.
This has not changed in 2000 or XP

This discussion is closed to new replies.