REPT

Repeats a string a number of times.

Syntax

=REPT(string, repetitions)

Arguments

ArgumentTypeDescription
stringStringThe specified string
repetitionsNumberThe number of times to repeat the string

Examples

=REPT("Hello!", 3)→"Hello!Hello!Hello!"

=REPT("na ", 8)→"na na na na na na na na"

=REPT("Nothing", 0)→""


Did this page help you?