SpreadJS 14
Formula Reference / Formula Functions / Text Functions / 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

    See Also