Table of Contents
About
REPT function is used to repeat a text string for a given number of times.
Function Type
Text
Purpose
Repeat a character or characters
Return value
Repeated text
Syntax
=REPT(text,number_times)
Arguments
text – Text string to repeat.
number_times – Number of times to repeat the text.
Example 1
Notes
When the value ‘0’ is used as the second argument, REPT function will return a null value.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)