The REPT() function is used to repeat a text, 'n' number of times. This can be used in interesting ways. For example, you can use this function to draw a bar chart within a cell.

Here is a sample spreadsheet which uses the REPT() function for in-cell charts. 

This spreadsheet holds the statistics of previous Wimbledon championship winners by Country. The range B3:B16 is named 'gentscount' and the range F3:F13 is named 'ladiescount'. Cell D2 is named 'maxbars' and it refers to the maximum width of the bar chart. You can view the various named ranges on the spreadsheet by clicking on the Name Box, which is available at the top towards the left of the Formula Bar.

Now let us look at the formula used in cell C3:

=REPT("|";B3/MAX(gentscount)*maxbars)

The first argument to the REPT() function denotes the text to be repeated. We use the pipe symbol or the vertical bar,  | , in this case to achieve a bar graph feel. 

The second argument denotes the number of times the text should be repeated. In this case, we divide each country's count [  B3   ] with the maximum value in the range 'gentscount' [  MAX(gentscount)   ] to denote each country's count on a scale of 0 to 1. We then multiply it by the maximum number of bars [ maxbars ] configured in the spreadsheet. So in any event, the maximum width of the bar will be in control as per the value in cell 'maxbars'.

Finally, we apply the 'Times New Roman' font for these cells since the letter spacing in this font is minimal. 

We then copy the formula in Cell C3 to the rest of the cells. Since this is a regular formula, as soon as you change the data in the cells, the in-cell chart is automatically redrawn. Go ahead, and give the above spreadsheet a try. Use the 'Click to Edit' button to interact with the spreadsheet.

Hope you find this useful. If you have any interesting uses of functions, share it with us.