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:
Based on the Excel spreadsheet above, the following REPT examples would return: