Overview
Grammar | REPEAT(text,number_times) | Repeats a text a specified number of times. |
Parameter 1 | text | Text to be repeated |
Parameter 2 | number_times | Number of repetitions |
Notes
The function supports two parameters, between which the first is of any type and the second is a number.
Example
Formula | Result | Notes |
---|---|---|
REPEAT("$",4) | $$$$ | |
REPEAT(B10,3) | hellohellohello | The content of the cell B10 is "hello". |