Microsoft KB Archive/42963: Difference between revisions
(importing KB archive) |
m (Text replacement - "&" to "&") |
||
Line 23: | Line 23: | ||
* Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0 | * Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0 | ||
It is impossible to use concatenation (& | It is impossible to use concatenation (&) in creating attached or unattached text in a chart. An example of a possible entry is as follows: | ||
<pre> =Sheet1.xls!$A$1 | <pre> =Sheet1.xls!$A$1 | ||
</pre> | </pre> | ||
An example of an invalid entry is as follows: | An example of an invalid entry is as follows: | ||
<pre> =Sheet1!$A$1& | <pre> =Sheet1!$A$1&Sheet1!$B$1 | ||
</pre> | </pre> | ||
=== Workaround === | === Workaround === |
Latest revision as of 14:14, 21 July 2020
Can't Concatenate Chart (Attached or Unattached) TextLast reviewed: November 4, 1994 |
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:
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 WorkaroundDo the concatenation in the spreadsheet first. |
KBCategory: kbusage |
Last reviewed: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.