The REPT Function is categorized under Excel Logical functions. The function will repeat characters a given number of times.

In financial analysis, we can use the REPT function to fill a cell or pad values to a certain length. We can also build histograms, a chart commonly used in financial modeling, using the function by translating values directly into a certain number of (repeated) characters.

**Syntax**: =REPT(text, 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.

**Example**: Let’s look at some Excel REPT function examples and explore how to use the REPT function as a worksheet function in Microsoft Excel:

**Syntax**: =REPT(A15,B15)

**Result**:

Based on the Excel spreadsheet above, the following REPT examples would return:

**Syntax**: =REPT(A16,B16)

**Result**: 0000000000

**Syntax**: =REPT(A17,B17)

**Result**: ReapeatReapeat

**Syntax**: =REPT(A18,B18)

**Result**: SoPhucSoPhucSoPhuc

**Syntax**: =REPT(A19,B19)

**Result**: @@@@@