Microsoft KB Archive/31165

Stringing Together (Concatenating) Text in Multiplan PSS ID Number: Q31165 Article last modified on 01-20-1989 PSS database name: D_MPlan

3.x 4.00

MS-DOS

Summary:

You can use the concatenation operator “&” to string text together in Multiplan. For example, if you have the text string “abc” in R1C1 and the text string “def” in R2C1, you can concatenate these two strings of characters in another cell with the formula R1C1&R2C1.

To enter the formula, do the following:


 * 1) Select the cell in which you want the characters to appear.
 * 2) Choose Value from the menu (or press the equals (=) sign).
 * 3) Enter the formula.

You will see the text string “abcdef” as the returned value of the cell.

Copyright Microsoft Corporation 1989.