REPT

Formula Explanation

Repeat a text string a certain number of times. Use REPT to fill cells with many instances of a text string.

Formula Syntax

Enter in the result column: 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 that specifies how many times the text should be repeated.

  • If number_times is 0 (zero), REPT returns an empty string ("").
  • If number_times is not an integer, it will be truncated to an integer.
  • The length of the REPT function result cannot exceed 32,767 characters, or else REPT returns #VALUE!.

Usage Example

Repeat the content of column ED2 three times and write the result in column ED3.

ED3 = rept(ed2,3)

✉️ Ask Tablize