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:

Where,

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

Example of CONCATENATE Function in Excel:

Formula

• 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