MS Excel – Formula : Repeat Characters

Description:

Repeats text a given number of times.

Syntex:

= 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.

Example:

Points to remember:

• Use REPT to fill a cell with a number of instances of a text string.
• If you want to repeat a text value or any characters in it, you can apply the REPT function to do that.
• It repeats the values as many times as specified in the formula.
• If number_times is 0 (zero), REPT returns “” (empty text).
• If number_times is not an integer, it is truncated.
• The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!.