Excel Function : CONCATENATE

Download now!

Excel Function : CONCATENATE




Joins several text items into one text item

Microsoft Excel Reference Page


Syntax and Description of the CONCATENATE Excel Function

The syntax for the CONCATENATE function in Microsoft Excel is: CONCATENATE(string1, [string2], ...) Where string1, string2, ... are the strings to be concatenated.

About CONCATENATE Excel Function

The CONCATENATE function concatenates a list of text strings into a single text string. The list of text strings can be provided as a range of cells, or as a list of text strings separated by a delimiter.