top of page

CONCATENATE

Concatenate/Merge conetns of two or more cells

The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined text string.

Syntax

Related

&

TEXTJOIN

CHAR(10)

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

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

OR

*

* Excel 2016

Note

  • In current versions of Excel (Excel 2007 and later), you can supply up to 255 text arguments to the Concatenate function, but in Excel 2003, the function can only accept up to 30 text arguments.

​

  • In Excel 2016, the Concatenate function has been replaced by the Concat function. However, the Concatenate function is still available in Excel 2016, to ensure compatibility with earlier versions of Excel.

bottom of page