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
- The values that has to joined should be separated by commas
- If you want space between the values then include space (“ ”) as shown above.