CONCATENATE (Primitive Spread Function) 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.

EXAMPLES:

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

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