REPT
Description
Returns a string where the specified text is repeated number_times times.
Syntax
REPT(
text
,
number_times
)
- text: The text to repeat.
- number_times: The number of times to repeat the specified text.
Example
Formula | Result |
|---|---|
=REPT(A1,2)
Where cell A1 contains
Always
.
| AlwaysAlways |
=A1 & REPT( "-", 8) & C1
Where cell A1 contains
Regional
and C1 contains
Manager
.
| Regional--------Manager |