Article updated on January 15, 2018

The REPT function repeats a specific text a chosen number of times.

Formula in cell D3:


Excel Function Syntax



text Required. The value you want to repeat.
number_times Required. The number of times you want to repeat the value.


A zero makes the REPT function return nothing.

A negative number or a text string returns a #VALUE error.