REPT Function

About

REPT function is used to repeat a text string for a given number of times.

Function Type

Text

Purpose

Repeat a character or characters

Return value

Repeated text

Syntax

=REPT(text,number_times)

Arguments

text – Text string to repeat.

number_times – Number of times to repeat the text.


Example 1


Notes

When the value ‘0’ is used as the second argument, REPT function will return a null value.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel