The REPT function Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
Syntax
- Text Required. The text you want to repeat.
- Number_times Required. A positive number specifying the number of times to repeat text.
| Data | Formula | Result |
| * | =REPT(A2, 10) | ********** |
| Kazam | =A3 & REPT(“*”, 10) | Kazam********** |
| 12000 | =A4 & “/-” & REPT(“*”, 5) | 12000/-***** |