Returns the specified text repeated the specified number of times.
Syntax
 Copy Code
|
|---|
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
Copy Code
|
|---|
=REPT("-",10) |
See Also
Function Reference
LEFT Function
MID Function
RIGHT Function
SUBSTITUTE Function