REPT function

Category: Text
Introduced: Excel 2003

Summary

Repeats text a given number of times

Syntax

REPT(text, number_times) The REPT function syntax has the following arguments:
• Text Required. The text you want to repeat.
• Number_times Required. A positive number specifying the number of times to repeat text.

Example

=REPT("*-", 3)
=REPT("-",10)

Microsoft Support Page

https://support.microsoft.com/en-us/office/rept-function-04c4d778-e712-43b4-9c15-d656582bb061

Back to Functions