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)""