Excel Rept Function

This post will guide you how to use Excel REPT function with syntax and examples in Microsoft excel.

Description

The Excel REPT function repeats a text string a specified number of times.

The REPT function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The REPT function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the REPT function is as below:

= REPT  (text, number_times)

Where the REPT function arguments are:
Text -This is a required argument. The text string that you want to repeat.
Number_times – This is an required argument.  The number of times that you want to repeat
Note: If number_times is zero, the REPT function will return empty text. And If number_times value is not an integer, it is truncated to an integer value.

Example

The below examples will show you how to use Excel REPT Text function to repeat a text string a given number of times.

#1 To repeat a text string in B1 cell 3 times, just using the following formula:= REPT (B1,3).

excel text function rept example1

Related Posts

How to Count Number of Cells that Contain Exactly N Characters in Excel
count number of cells that contain certain characters2

This post will guide you how to count the number of cells that contain exactly N charcters within a range of cells using a formula in Excel 2013/2016.You can easily to count cells equal to a specific value or text ...

Extract Email Address from Text
exctract email address from text3

This post will guide you how to extract email address from a text string in Excel. How do I use a formula to extract email address in Excel. How to extract email address from text string with VBA Macro in ...

Reverse Concatenate Formula in Excel
reverse concatenate function7

This post will guide youw how to reverse the concatenate function in Excel. how do I split the text string into the muliptle cells with a formula in Excel. How to split text data of a cell to multiple cells ...

How to extract nth word from text string
extract nth word4

This post will guide you how to extract the nth word from a text string in excel. How do I get the nth word from text string in a cell using excel formula. How to write a User Defined Function ...

How to extract word that containing a specific character
extract word contain specific character4

This post will guide you how to extract word that containing a specific character using formula in excel. How to get a word that contains a specific character (such as: @, comma, hash, etc.) in a text string in one ...

How to extract word that starting with a specific character
extracts word begins specific character5

This post will guide you how to extract a word that starts with a specific character in excel. Extract word that starting with a specific character For example, Assuming that you have a text string that contains email address in ...

How to Extract Text between Commas
extract text between commas 4

This post will guide you how to extract text between commas in excel. Before we talked that how to extract text between brackets using a formula with MID and SEARCH functions. And this post will extract text between commas instead ...

How to Split Multiple Lines from a Cell into Rows
split multiple line from a cell3

This post will guide you how to split multiple lines from a cell into separated rows or columns in Excel. You will learn that how to extract text string separated by line break character into rows in excel 2013. In ...

Excel Replace Function Remove Text String
Excel Replace Function Remove Text String1

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Combining the REPLACE Function with FIND Function to Remove Text in Excel
Combining the Replace function with Text function 2

How to remove a text string or characters from a cell when the text is at a specific position. And this post will guide you how to remove a text string from a cell or column that the removed text ...

Sidebar