FUNCTION REPT (REPEAT)
REPT (REPEAT)
This function repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
How does it work?
=REPT(text,number_times)
Where
Text is the text you want to repeat. This may include the text itself in inverted commas or the cell reference where the text lies.
Number_times is a positive number specifying the number of times you want to repeat text.
Remarks
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!.
This function repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
How does it work?
=REPT(text,number_times)
Where
Text is the text you want to repeat. This may include the text itself in inverted commas or the cell reference where the text lies.
Number_times is a positive number specifying the number of times you want to repeat text.
Remarks
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!.
Comments
Post a Comment
Your Valuable Comments are Appreciated