REPT Function in Excel | Advance Excel Course

The REPT Function is categorized under Logical functions in MS Excel. The function will repeat characters/ text a given number of times.

Syntax

=REPT(text, number_times)

Arguments 

1. Text: This is the text we want to repeat.

2. Number_times: This is the positive number that specifies the number of times to repeat given text.


Example