REPT

Microsoft Office Spreadsheet Functions

Show All

REPT

See Also

Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.

Syntax

REPT(text,number_times)

Text   is the text you want to repeat.

Number_times   is a positive number specifying the number of times to repeat text.

Remarks

  • If number_times is 0 (zero), REPT returns "" (empty text).

  • If number_times is not an integer, it is truncated.

  • The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

How?

Formula Description (Result)
=REPT("*-", 3) Displays the string 3 times (*-*-*-)
=REPT("-",10) Displays a dash 10 times (----------)