REPT Function in Excel

The REPT function in Excel is a text function that allows you to repeat a given text string a specified number of times

Syntax

=REPT(text, number_times)

Arguments

1. text: text string that you want to repeat.

2. number_times: the number of times that you want to repeat the text string.

Example

Scroll to Top