Functions
REPT
Repeat text N times
Try it
When to use it
When should I use REPT?
Use REPT to repeat a piece of text a set number of times, for example to build a simple in-cell bar chart or a fixed-width separator.
Can REPT make a text-based progress bar?
Yes — repeating a block character a number of times proportional to a value produces a quick in-cell bar without any chart.
Use cases
Repeat a short string several times
Create a fixed-width separator line
Used in
Syntax
REPT(text, number_times)