REPT
Repeats text a given number of times.
TextText CleaningText Processing
What it does
Repeats a string N times.
Syntax
REPT(text, number_times)
Arguments
text(text) — String.number_times(number) — Count.
Examples
In-cell Bar
Repeat '|' 5 times.
FORMULA
=REPT("|", 5)RESULT
|||||
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 5 |