How to use the Excel REPT function

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:

excel rept function 1 - How to use the Excel REPT function

Syntax:  =REPT(A15,B15)

Result:

excel rept function - How to use the Excel REPT function

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: @@@@@

Add a Comment

Your email address will not be published. Required fields are marked *