You are currently offline, waiting for your internet to reconnect

How to combine cells of information in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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

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&" "&B1&" "&C1
References
For more information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
113237 Visual Basic macro to concatenate columns of data
290359 How to remove leading space for values converted to strings
154873 Error when you concatenate string and numeric values
 add merge join  XL2003 XL2007 XL2010
Properties

Article ID: 280388 - Last Review: 09/23/2015 06:48:00 - Revision: 9.0

Microsoft Excel 2010, Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel for Mac 2011, Excel 2016, Microsoft Excel 2013

  • kbhowto KB280388
Feedback