<< Click to Display Table of Contents >> CONCATENATE (concatenate text strings)

Note: CONCATENATE is supplemented by the new function CONCAT with additional functionality, which is available in newer versions of Microsoft Excel (2019 or later).

Syntax:

CONCATENATE(String1 [, String2, String3 ...])

Description:

This combines two or more text strings into one text string.

Additional info:

The & operator does exactly the same: CONCATENATE("Text1", "Text2") is equivalent to "Text1" & "Text2".

Example:

CONCATENATE("Good ", "Morning") returns Good Morning

CONCATENATE(2, " slices", " of ", "bread") returns 2 slices of bread

See also:

CONCAT, TEXTJOIN