How to use Excel REPT Function

Introduction

REPT function in excel is a built in text/string function. This function is used to repeat characters a given number of times. For example, =REPT(A, 2) gives AA as the result. It is also used as worksheet function and can be entered in cell of a worksheet.

Syntax

=REPT(Text, Number )

Arguments

Text: It is the text or reference to a cell containing the text, which will be repeated

Number: Number of times you wants to repeat the text.

Keynotes

  • This function can also be used to make a histogram.
  • If 0 is entered in number argument, REPT gives empty text as result.
  • Its result cannot be larger than 32767 characters, otherwise #VALUE error is displayed.

Examples

In this example, some characters are entered in column A, REPT function is used to repeat these characters three times in column B.

Leave a Comment