Excel allows us to repeat a text or character for a specified number of times by using the **REPT **function. This tutorial will assist all levels of Excel users in using the REPT function.

*Figure 1. Final result of the REPT function*

**Syntax of the DMIN Function**

Repeats text for a specified number of times

**Syntax**:

`=`

**REPT**(**text, number_times**)

**text**– the text we want to repeat.**number_times**– the number of times to repeat the text; must be a positive number

**Setting up our Data**

Our data consists of three columns : Text (column B), Number of times (column C) and Result (column D). The result of the REPT function will be in column D.

* Figure 2. Sample data for the REPT function*

Repeat text using the REPT Function

In order to repeat a given text for a specified number of times, let us follow these steps:

**Step 1**. Select cell D3

**Step 2**. Enter the formula: `=REPT(B3,C3)`

**Step 3**. Press ENTER

**Step 4**. Select cell D3 and drag down the “+” icon at the lower-right corner of the cell to copy the formula to cells D4 and D5

*Figure 3. Entering the formula for REPT function*

The result in cell D3 is “appleapple”, which repeats the text “apple” two times. The formula also repeats “Hi!” three times and “1_” four times resulting to “Hi!Hi!Hi!” and “1_1_1_1_” in cells D4 and D5.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment