CONCATENATE Function

About

The Excel CONCATENATE function is a TEXT Function that can be used to combine text strings.

CONCATENATE function can handle up to 255 individual arguments.

Function Type

Text

Purpose

Combine data

Return value

Concatenated data (Text joined together)

Syntax

=CONCATENATE(text1, [text2], ...)

Arguments

text1 – The first text value to join

text2 – [optional] The second text value to join.


Examples


Notes

From Excel 2019, CONCAT function replaces CONCATENATE function. However, CONCATENATE function will stay available for the compatibility of earlier versions of Excel.

TEXTJOIN function another Excel function which can be used to combine text strings.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel