Excel Concatenate Function - Easy Excel Tutorial

Concatenate is simple an Excel workbook function “to combine” or “to join together”. This function allows you to combine text from different cells into one cell.The Excel CONCATENATE function concatenates (joins) join up to 30 text items together and returns the result as text. The CONCAT function replaces CONCATENATE in newer versions of Excel.

For example, we have a worksheet containing names and surname information. We want to combine the Last Name and First Name columns in each row into the Full Name column.

We enter the arguments for the CONCATENATE function, which tell the function which cells to combine. We want to combine the first two columns, with the First Name (column C) first and then the Last Name (column D). So, our two arguments for the function will be C2 and D2.

Return value

Text joined together.

Syntax

=CONCATENATE (text1, text2, [text3], ...)

Note : Up to thirty pieces of text can be joined.

Arguments

text1 - The first text value to join together.

text2 - The second text value to join together.

text3 - [optional] The third text value to join together.

Note

You can achieve the same result by using the & operator.