Article updated on January 15, 2018

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

Formula in cell D3:

=REPT(B3,C3)

Excel Function Syntax

REPT(text,number_times)

Arguments

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

Comments

A zero makes the REPT function return nothing.

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