This function combines multiple text strings or numbers into one text string.

Syntax

CONCATENATE(text1,text2,...)

Arguments

The arguments can be strings, formulas that return a string, or references to cells containing a string. Up to 255 arguments may be included.

Data Types

Accepts string data for both arguments. Returns string data.

Examples

CONCATENATE(B4,D5)

CONCATENATE(R4C2,R5C4)

CONCATENATE(""Gold "", ""Medal"") gives the result Gold Medal

Version Available

This function is available in product version 1.0 or later.

See Also

CHAR | EXACT | Text Functions