CONCAT Function in Excel

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

Syntax of CONCAT Function in Excel:

CONCAT( text1, [text2], … )

Where,

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

 

Example of CONCAT Function in Excel:

Formula

CONCAT Function in Excel 1

  • If you want space between the values then include space (“ ”) as shown above.
  • In the first set of examples the CONCAT function joins the three set of strings that is given separately
  • In the second set of examples the CONCAT function joins the string that is passed together as a single array.

Result

CONCAT Function in Excel 2

previous CONCAT Function in Excel                                                                                                                next CONCAT Function in Excel