REPT Function

Question:     How do I display the total sales amount by way of a chart?  I don’t want to use the normal chart options given in Microsoft Excel. Is there an alternative to the normal chart options?

Answer:        Yes, the REPT function

Why:            Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string



  • Text  Required. The text you want to repeat
  • Number_times Required. A positive number specifying the number of times to repeat text

 Applies To: MS Excel 2003, 2007, 2010

 1.  The screen shot below will be used to illustrate this example

2.  Select cell D4 and type =REPT(“I”,C4) & C4
3.  The result will be as follows

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations