CONCATENATE

Name

Concatenate

Description

Combines multiple text strings or numbers into one text string.

Syntax

CONCATENATE(text1, text2, ...)

Remarks

Accepts up to 30 arguments. Arguments can be strings, formulas that return a string, or references to cells containing a string.

Data Type

Accepts string data for all arguments. Returns string data. For more information, see Data Type for Each Cell Type.

Example

fpSpread1.Formula = "CONCATENATE(""Gold "", ""Medal"")" equals "Gold Medal"

In the following example, cell A1 contains "Baker", cell A2 contains " runs", and cell A3 contains " the 5-mile race.".

fpSpread1.Formula = "CONCATENATE(A1,A2,A3)" equals "Baker runs the 5-mile race."