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
- 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.