<< 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(Text1 [, Text2, Text3 ...])
Description:
Combines two or more text strings into one text string.
Annotation:
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: