The REPT function in Excel is a text function that allows you to repeat a given text string a specified number of times

Syntax

=REPT(text, number_times)

Arguments 

1. text: text string that you want to repeat.

2. number_times: the number of times that you want to repeat the text string.


Example