CONCATENATE Function in Excel – Join strings and values in Excel

CONCATENATE Function in Excel joins together a set of supplied text strings or other values, into one combined text string.

Syntax of CONCATENATE Function in Excel:

CONCATENATE( text1, [text2], … )

Where,

text1, [text2] – set of text arguments that you want to join together into single text string.

Example of CONCATENATE Function in Excel:

Formula

CONCATENATE Function in Excel 1

The values that has to joined should be separated by commas
If you want space between the values then include space (“ ”) as shown above.

Result

CONCATENATE Function in Excel 2