Excel REPT Function

HomeExcel FunctionsExcel REPT Function (Example + Sample File)


The Excel REPT Function is listed under Microsoft Excel's Text Functions category. It returns a text value several times. In simple words, with REPT function you can specify a text, and a number to repeat that text and in the result, REPT will repeat that text.

How to use it

To learn how to use the REPT function in Excel, you need to understand its syntax and arguments:


REPT(value1, [value2], …)


  • value1: A cell reference, an array or a number that is directly entered into the function.
  • [value2]: A cell reference, an array or a number that is directly entered into the function.


  • You can specify up to 255 arguments.
  • It can count numbers, dates, and text which represent numbers.
  • If you enter a logical value or text representation of a number directly into the function it will count them.
  • Text and ERROR values will be ignored.
  • If you specify a reference or an array, count function will only return the number of cells that have a numeric value.


To master the REPT function we need to try it out in an example and below is one which you can try out:

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.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.