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

previous CONCATENATE Function in Excel                                                                                                                 next CONCATENATE Function in Excel