Microsoft KB Archive/30529

{| = Concatenating Text and Numeric Values =
 * width="100%"|

Last reviewed: November 30, 1994

Article ID: Q30529 The information in this article applies to:
 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0
 * Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0

To concatenate text strings in Microsoft Excel, the concatenation symbol (&) text operator is used. For example, if you want to concatenate cells A1 and A2, type the following:

=a1&a2 For more information about using the concatenate function in Microsoft Excel version 5.0, choose the Search button in Help and type: CONCATENATE function