Spread.NET 17 Formula Reference
Formula Functions / Functions R to S / REPT
In This Topic
    In This Topic

    This function repeats text a specified number of times.




    This function has these arguments:

    Argument Description
    text Text you want to repeat
    number Number of times you want to repeat the text; if not an integer, the number is truncated; if zero (0), returns empty (" ")


    The result of this function must be less than or equal to 255 characters.

    Data Types

    Accepts string data for the text argument and numeric data for the number argument. Returns string data.


    REPT(D9, 2)

    REPT(R9C4, 2)

    REPT(""*4"", 3) gives the result *4*4*4

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    CONCATENATE | Text Functions