How to use the Excel CONCATENATE function

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:

CONCATENATE - How to use the Excel CONCATENATE function

Syntax:  =CONCATENATE(A2,B2)

Result:

CONCATENATE 1 - How to use the Excel CONCATENATE function

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

READ:  How to use max function in excel

Add a Comment

Your email address will not be published. Required fields are marked *