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."