How to combine cells of information in Excel (280388)


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 Macintosh Edition
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.

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

Modification Type:MinorLast Reviewed:8/18/2005
Keywords:kbhowto KB280388
©2004 Microsoft Corporation. All rights reserved.