XL97: Only 1,024 Characters Are Displayed in a Cell

ID: Q156881

The information in this article applies to:

SYMPTOMS

In Microsoft Excel 97, if a cell contains more than 1,024 characters, or if it contains a formula that returns a result of more than 1,024 characters, only approximately the first 1,024 characters are displayed in the cell.

STATUS

This behavior is by design of Microsoft Excel 97.

MORE INFORMATION

A cell in Microsoft Excel 97 can contain up to 32,767 characters. However, if a cell contains more than 1,024 characters, the following rules apply:

NOTE: You may be able to see more than 1,024 characters based on the column width or row height of the worksheet and the display settings of the system.

You can observe this behavior by following these steps:

1. In cell A1 of a new worksheet, type the following formula:

      =REPT("w",1024)&"xyz"

2. With cell A1 selected, click Cells on the Format menu.

3. Click the Alignment tab. Click to select the Wrap Text check box, and

   click OK.

4. On the Format menu, point to Column, and click AutoFit Selection.

   Note that all you can see in cell A1 are "w" characters; the "xyz"
   characters at the end of the cell are not displayed.

5. Type the following formulas in cell A2 and A3:

      A2: =RIGHT(A1,3)
      A3: =LEN(A1)

   The formula in cell A2 returns the result "xyz", the three rightmost
   characters in the cell. Cell A3 contains the number 1027, the number of
   characters present in cell A1.

6. Change the formula in cell A1 to:

      =REPT("w",1023)&"xyz"

You can see 1,023 "w" characters, followed by an "x" character. The "yz" characters are after the 1,024-character limit, so they are not displayed. The formula in cell A3 now displays 1026, the length of cell A1.

Additional query words: XL97 8.0 1025 1024

Keywords          : kbualink97 xlui xlformula kbfaq
Platform          : WINDOWS

Last Reviewed: May 25, 1999