Microsoft KB Archive/42963

-

{| 2.x 3.00 4.00 4.00a 5.00 | 2.20 2.21 3.00 WINDOWS                 | OS/2 kbusage The information in this article applies to:
 * width="100%"|


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0

It is impossible to use concatenation (&) in creating attached or unattached text in a chart. An example of a possible entry is as follows:

=Sheet1.xls!$A$1 An example of an invalid entry is as follows: =Sheet1!$A$1&Sheet1!$B$1

Workaround
Do the concatenation in the spreadsheet first.
 * }

-

Last reviewed: November 4, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.