REPT Function in Excel - Repeat Values

Add to Favorites
Author:

Quickly repeat a value, character, or number within a cell in Excel.  This is a neat little function that is easy to use and can help to create some unique elements within the spreadsheet or just perform a simple character repeat.

Syntax

=REPT(text, number_times)

ArgumentDescription
Text What you want to repeat, surrounded by double quotation marks.

Number_times

How many times you want to repeat the text.

Example

  1. Type =REPT(

  2. Put the text or characters that you want repeated within double quotation marks.
  3. Type a comma and then input how many times you want to repeat it.
  4. Hit Enter and that's it.

Notes

You can do this with text, numbers, characters, basically anything you can type in-between two quotation marks.

The value in the cell will still be a function, if you want to turn it into the text that you see, use this tutorial to change formulas into their output values in Excel.

Make sure to download the accompanying tutorial to see this function in the worksheet.


Excel Function: REPT()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.