REPT Function
Written by kazamraza
no comments
Classified in : Excel Formulas, Text Functions
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
REPT(text, number_times)
The REPT function syntax has the following arguments:
- Text Required. The text you want to repeat.
- Number_times Required. A positive number specifying the number of times to repeat text.
| ◢ | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Data | Formula | Result | ||
| 2 | * | =REPT(A2, 10) | ********** | ||
| 3 | Kazam | =A3 & REPT("*", 10) | Kazam********** | ||
| 4 | 12000 | =A4 & "/-" & REPT("*", 5) | 12000/-***** |
Related Article