REPT function. Repeat the specified string a specified number of times.(Microsoft Excel)
Repeat the specified string a specified number of times.
How it works
=REPT(Text, Number_times)
| Name | Omission | Specify |
|---|---|---|
| Text | Required argument. | Target Text. |
| Number_times | Required argument. | If the function result exceeds 32,767 characters, #VALUE! error. |
Example Results
The REPT function can be used to create strings more efficiently and accurately than repeated copy and paste.
---