The REPT function to repeat a specific text for a specific number of times. In simple words, it can repeat a text in a cell the number of times you specified.
You just need to specify a text to repeat and the number of repetition. In the below example, we have used it to repeat a text bar 50 times.
In the below example, we have used different types of text for repetition using with REPT function.
It can repeat any type of text or numbers and even symbols which you specify in function and the main use of REPT function is for creating in-cell charts.
In the below example, we have used REPT function to create an in-cell column chart. You can use REPT Function in different ways to create some good looking tiny charts.
This function is the part of the list of Excel’s top 100 functions [with examples] and from here you can also learn some amazing formula tips.