# 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.

Syntax

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.

**DOWNLOADABLE RESOURCES**

ShowRatings-01

.xlsx

Download XLSX • 9KB