EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources TEXT and String Functions in Excel Excel REPT Function

Excel REPT Function

Madhuri Thakur
Article byMadhuri Thakur

Updated May 3, 2023

REPT Function in Excel

REPT Function in Excel

Rept function in Excel returns the text value of any cell or cell range and repeats those text range in a cell with a number of repetition we allow. For example, in 3 selected cells have One, Two and Three as text values, so using Rept function, we can call all the select text values in one cell and repeat them as well more than 1 time if required in the same cell.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

REPT Formula in Excel:

The Formula for the REPT Function in Excel is as follows:

REPT Formula in Excel

Where the supplied arguments are:

  • Text – The text you want to repeat.
  • Number_times – The number of times to repeat that text.

As the REPT function is a built-in function in excel and categorized under the Text/String functions category, thus it’s listed under the FORMULAS tab. Please follow the below steps:

  • Click on the FORMULAS tab.
  • Select the Text functions category. It will open up a drop-down list.

REPT Function Step 1

  • Click on the REPT function from the listed functions.

REPT Function Step 2

  • After clicking on the REPT function, a Function argument box will open up.

REPT Function Step 3

  • Pass the first argument of the REPT function, which is text. The text which you want to repeat.
  • The second argument is Number_times, it specifies the number of times to repeat the text. It is a positive number.

How to Use REP Function in Excel?

REPT Function in Excel is very simple and easy to use. Let’s understand the working of REPT in Excel by Some Examples.

You can download this REPT Function Excel Template here – REPT Function Excel Template

Example #1

We have given the below data:

REPT Example 1

Now we will apply the REPT function on the above data:

REPT Example 1-1

As per the above screenshot, the REPT function will repeat the character “_“ hyphen 5 times.

REPT Example 1-2

Now drag & drop this function for the below values.

REPT Example 1-3

The final result is:

REPT Example 1-4

Example #2

We also can apply the REPT function on a string as well.

REPT Example 2

We will apply the REPT function here

REPT function 2-1

The results are:

REPT Example 2-2

Now drag & drop this function for the below values.

REPT Example 2-3

Example #3

To create a simple in-cell chart or column chart, we will use the REPT function. Here we will use percentage data to create the cell chart.

REPT Example 3

The steps are as follows:

  • Please increase the size/height of the row where you want to insert the chart so that the column bar will adjust in it.

REPT Example 3-1

  • Insert the REPT function formula in cell A30 and enter.

REPT Example 3-2

The result is:

REPT Example 3-3

  • Now, change the orientation of the text to “Rotate Text Up” as per the below screenshot.

REPT Example 3-4

  • Change the font style to PLAYBILL and alignment to bottom & center.

REPT Example 3-5

  • Apply the same steps for the rest values.
  • Finally, you will get the In-cell column chart.

REPT Example 3-6

With the same steps, you can also create an In cell bar chart too.

Example #4

We have given the financial data, and it is needed to make all the numbers of the same length. For this, we will add Zero in the numbers in such a way so that the value of the number doesn’t change.

REPT Example 4

We want all the numbers should be of length 5. For this, we will use the REPT function:

REPT Function 4-1

The result is:

REPT Example 4-2

Drag & drop the above function for the rest values, and the final results are:

REPT Example 4-3

Explanation:

  • We will first take the length of the string.
  • Then subtract the length from 5 (mentioned length which we want to make for all numbers).
  • REPT function will return the number of 0’s based on the number, which occurs after subtracting from the number 5.

For example, If the number is 91, it would return 000.

Things to Remember

  • If the second argument number_times is Zero, the function returns an empty string.
  • If number_times is a decimal value, it will truncate to an integer. For example, if the values are 5.93, it will only consider 5.
  • The result of the REPT function must be no longer than 32,767 characters. Otherwise, it will return #VALUE! error.

Recommended Articles

This has been a guide to REPT in Excel. Here we discuss the REPT Formula in Excel and how to use the REPT Function in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  1. IRR Excel Function
  2. RIGHT Function Excel
  3. LEN Function in Excel
  4. HLOOKUP in Excel
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
All in One Excel VBA Bundle500+ Hours of HD Videos | 15 Learning Paths | 120+ Courses | Verifiable Certificate of Completion | Lifetime Access
Financial Analyst Masters Training Program2000+ Hours of HD Videos | 43 Learning Paths | 550+ Courses | Verifiable Certificate of Completion | Lifetime Access
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download REPT Function Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download REPT Function Excel Template

EDUCBA

डाउनलोड REPT Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more