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.
Contents
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.
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”)