Spread Formula Reference
Formula Functions / Functions A to C / CONCATENATE
In This Topic
    CONCATENATE
    In This Topic

    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