|
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.
Recent Comments