The Excel’s Concatenate function can be used to join up contents of multiple cells into one cell.

The syntax for the CONCATENATE function is
=CONCATENATE(text1, text2)

When can “Concatenate” function come in handy??

When say first name is given in column A and last name in column B and you want to combine the two.
Concatenate function can help you do this as shown below:

But notice there is no space between the two so if you want to insert a space you can modify your concatenate function as follows:

Points to remember:
Concatenate function uses contents of other cells(like A and B here). So if the linked data is changed, the concatenated cell( Say C1) would change as well. And if you delete the related columns then you will get a reference error in the concatenated cell.To overcome this, you can either hide column A and B or simply copy the contents of column C and use paste special values command under the “Edit” tab.

An alternative to concatenate function:

The ampersand (&) operator can also be used instead of the CONCATENATE function to do the same task.

So in our example above if we enter =A1&B1 in cell C1, it would give the same value as =CONCATENATE(A1,B1) as shown below:

Popularity: 14%