Skip to main content

REPT

Repeats given text a specified number of times

Syntax

=REPT(Text, NumTimes)

Arguments

NameDescription
TextText to repeat.
NumTimesPositive 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

FunctionResult
=REPT("Sample", 3)"SampleSampleSample"