The Excel CONCATENATE function concatenates (joins) join up to 30 text items together and returns the result as text. The CONCAT function replaces CONCATENATE in newer versions of Excel.
Syntax: =CONCATENATE(text1, [text2], …)
The CONCATENATE function syntax has the following arguments:
- text1 (required): The first item to join. The item can be a text value, number, or cell reference.
- text2, … (optional) Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters.
Example: Let’s look at some Excel CONCATENATE function examples and explore how to use the CONCATENATE function as a worksheet function in Microsoft Excel:
Syntax: =CONCATENATE(A2,B2)
Result:
Syntax: =CONCATENATE(A3,B3)
Result: SmithKenvin
Syntax: =CONCATENATE(A4,B4)
Result: JohnMann
Syntax: =CONCATENATE(A5,B5)
Result: DayBridges
Syntax: =CONCATENATE(A6,B6)
Result: PaulColemanJonesAmy
Syntax: =CONCATENATE(A6,B6)
Result: JonesAmy
