Skip to Content

REPT

Repeats text a given number of times

Syntax

REPT(text, number_times)

Parameters

  • 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)
Returns: StringSince: Excel 2003