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

ERROR: si-captcha.php plugin: GD image support not detected in PHP!

Contact your web host and ask them to enable GD image support for PHP.

ERROR: si-captcha.php plugin: imagepng function not detected in PHP!

Contact your web host and ask them to enable imagepng for PHP.