top of page

Learn how to use the REPT(repeat) Function in Excel

Use the REPT function to show any type of Rating based on a percentage

The REPT function in Excel helps users repeat a text string, characters, symbols, etc., a required number of times.

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


REPT(text, number_times)

The REPT function syntax has the following arguments:

  • Text Required. The text you want to repeat.

  • Number_times Required. A positive number specifying the number of times to repeat text.


Download XLSX • 9KB

571 views0 comments

Recent Posts

See All


bottom of page