All functions / Text

REPT

Repeats text a number of times.

Syntax

=REPT(text, number_times)

Arguments

• text: The text (or a cell containing it).
• number_times: How many times.

Example

=REPT("★", 4) → "★★★★"

Practise it

• Text surgery with nested formulas