Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to combine cells of information in Excel
Article ID: 280388 - View products that this article applies to.
This article was previously published under Q280388
In Microsoft Excel, it is possible to combine, or concatenate, different cells of data into one cell. This article contains two examples.
Simple ConcatenationThe following formula combines data from cells A1, B1 and C1. Write this formula into another column, such as column D1:
Add Spaces Between Each ColumnThe 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&" "&B1&" "&C1
For more information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/113237/ )Visual Basic macro to concatenate columns of data
(http://support.microsoft.com/kb/290359/ )How to remove leading space for values converted to strings
(http://support.microsoft.com/kb/154873/ )Error when you concatenate string and numeric values
Article ID: 280388 - Last Review: September 18, 2011 - Revision: 6.0