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
Expand all | Collapse all

On This Page

SUMMARY

In Microsoft Excel, it is possible to combine, or concatenate, different cells of data into one cell. This article contains two examples.
Back to the top | Give Feedback

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
Back to the top | Give Feedback

REFERENCES

For more information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
113237
(http://support.microsoft.com/kb/113237/ )
Visual Basic macro to concatenate columns of data
290359
(http://support.microsoft.com/kb/290359/ )
How to remove leading space for values converted to strings
154873
(http://support.microsoft.com/kb/154873/ )
Error when you concatenate string and numeric values
Back to the top | Give Feedback

Properties

Article ID: 280388 - Last Review: September 18, 2011 - Revision: 6.0
APPLIES TO
  • 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
  • Microsoft Office Excel 2003
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
Keywords: 
kbhowto KB280388
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top