Apr 07

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
or
=CONCATENATE(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
or
=CONCATENATE(A1,” “,B1,” “,C1)
PS: If you have multiple rows just copy the formula to other rows.

written by MG \\ tags: ,


Leave a Reply

*