REPT

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. 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 255 characters.

Tip   You can use this function to create a simple histogram on your worksheet.

Examples

REPT("*-", 3) equals "*-*-*-"

If A3 contains "Sales", then:

REPT($A$3, 2.9) equals "SalesSales"