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

    This function repeats text a specified number of times.

    Syntax

    REPT(text,number)

    Arguments

    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 (" ")

    Remarks

    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.

    Examples

    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