Microsoft KB Archive/280388

= How to combine cells of information in Excel =

Article ID: 280388

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 2004 for Mac
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q280388



SUMMARY
In Microsoft Excel, it is possible to combine, or concatenate, different cells of data into one cell. This article contains two examples.



Simple Concatenation
The following formula combines data from cells A1, B1 and C1. Write this formula into another column, such as column D1:

=A1&B1&C1

Add Spaces Between Each Column
The following formula combines data from cells A1, B1 and C1 and adds spaces between each set of data. Write this formula into another column, such as column D1:

=A1&&quot; &quot;&B1&&quot; &quot;&C1

