Skip to main content
Version: Streamsheets 3.0

REPT

Repeats given text a specified number of times

Syntax

=REPT(Text, NumTimes)

Arguments

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

Return

TypeDescription
StringRepeated Text string.

Examples

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