How to use CONCAT function in Excel

CONCAT is a newly introduced function available in MS office version 2019 and office 365. CONCAT unlike CONCATENATE accepts range of cell in addition to individual cells.

Syntax

CONCAT(text1, [text2],………….)

Here argument one i.e., text1 is required and cannot be omitted, but argument after first one are optional. CONCAT function comes with limit of 255 items and Total of 8192 character.

Use of CONCAT function in Excel

Concatenate text from cells

If text you want to concatenate (join) is in 2 different cell A1 and B1, use excel formula as below

Syntax

=CONCAT(A1,B1)

Concatenate text from Range of cells

To concatenate text from range of cells, use below formula in excel

Syntax

=CONCAT(A1:A10)

Concatenate text from string

If you want to concatenate string of text, use excel formula as below

Syntax

=CONCAT(“String 1”, “String 2”)

Concatenate text with date or time

To concatenate date or time functions with text use below formula

Syntax

=CONCAT(“String 1”,TEXT(B1, “mmmm”))

TEXT function will get details from cell B1 (should contain date) and return Month.

use CONCAT function in Excel

Concatenate text with comma

To concatenate text with comma use syntax as below

Syntax

=CONCAT(“String 1”, ” ,” , “String 2”)

Concatenate text with space

To concatenate text with comma use syntax as below

Syntax

=CONCAT(“String 1”, ” ” , “String 2”)

Concatenate text with &

To concatenate text with comma use syntax as below

Syntax

=CONCAT(“String 1”, ” & ” , “String 2”)