REPT

Repeats given text a specified number of times

Syntax

=REPT(Text, NumTimes)

Arguments

Name

Description

Text

Text to repeat.

NumTimes

Positive number which defines the number of times to repeat text. If NumTimes is 0, REPT returns an empty string.

Return Value

Repeated text string.

Example

Function

Result

=REPT(“Sample”, 3)

“SampleSampleSample”