Microsoft KB Archive/94861

= Microsoft Knowledge Base =

Excel: Editing R1C1 Formatted Cells Doubles Spaces
Last reviewed: September 12, 1996

Article ID: Q94861

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

SYMPTOMS
In Microsoft Excel, if you are using the R1C1 reference style, the spaces between the R1 (row) and C1 (column) components of a cell reference will be doubled every time you edit the cell in which they are contained.

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem was corrected in version 5.0 of Microsoft Excel for Windows.

MORE INFORMATION
This problem occurs only when Microsoft Excel is using the R1C1 reference style. The only adverse effect of these extra spaces is that the formula may come close to exceeding the 255 character-per-cell limit.