Documentation/Calc Functions/REPT

Function name:
REPT

Category:
Text

Summary:
Creates a new text string by concatenating multiple copies of a supplied string.

Syntax:
REPT(Text; Number)

Returns:
Returns a text string that comprises a specified number of copies of a supplied string.

Arguments:
Text is a text string (in quotation marks), a number, or a reference to a cell containing one of those types, that specifies the string to be repeated.

Number is a non-negative integer, or a reference to a cell containing a non-negative integer, that is the number of repetitions required.


 * If Number is non-numeric, then REPT reports a #VALUE! error.
 * If Number is a non-integer value, then REPT truncates it to an integer value.
 * If Number is less than 0, then REPT reports an invalid argument error (Err:502).
 * If Text is equal to the empty string or Number is equal to 0, then REPT returns the empty string.
 * The length of the string to be returned is limited to be less than 256 * (1024)2 characters. If the arguments passed would cause this limit to be exceeded, REPT reports a string overflow error (Err:513).

Additional details:
None.

Related LibreOffice functions:
None.

ODF standard:
Section 6.20.18, part 2

Equivalent Excel functions:
REPT