REPT

Returns the specified text repeated the specified number of times.

Syntax

REPT( Text text, Integer count ) → Text

Parameters

text

Required. The text to repeat.

count

Required. The number of times to repeat the text. Must be a positive integer.

Remarks

If count is 0, the function returns an empty text. If count is less than 0, REPT returns the #VALUE! error value. If count is not integer, it is automatically truncated.

Example

Formula

=REPT("-",10)

See Also

Function Reference
LEFT Function
MID Function
RIGHT Function
SUBSTITUTE Function