- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Statistical - REPT Function
Description
The REPT function 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)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Text | The text you want to repeat. | Required |
Number_times | A positive number specifying the number of times to repeat text. | Required |
Notes
If number_times is 0 (zero), REPT returns "" (empty text).
If number_times is not an integer, it is truncated.
The result of the REPT Function cannot be longer than 32,767 characters, or REPT returns #VALUE! error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_statistical_functions.htm
Advertisements