Articles → EXCEL FORMULA → Rept Function In Excel

Rept Function In Excel

In this article, we will discuss the Rept function in Excel.

Purpose

The Rept function repeats the character a specified number of times.

Sample Data

Consider the following data: -

Picture showing the sample excel file with data

Click to Enlarge

Rept Function Syntax

Use the following syntax: -

=Rept(<character_to_be_repeated>, <number_of_times>)

Picture showing implementing the Rept function in excel

Click to Enlarge

Output

Picture showing the output of Rept function in excel

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Monday, May 15, 2023

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**