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