REPT Function in Excel – Repeat the string in Excel

REPT Function in Excel repeats the string for a specified number of times

Syntax of REPT Function in Excel (Repeat Function):

REPT( text, number_times )

Where,

  • text –Text String to be repeated
  • number_times – number of times the text string to be repeated.

 

Example of REPT Function in Excel (Repeat Function):

Formula

REPT Function in Excel 1

  • Excel REPT Function, takes the text string and the number of repetition as arguments
  • In Row number 5 the number of repetition is 0 so REPT Function returns the empty string.
  • From Row number 2 to 4 the REPT Function repeats the strings to the specified number of times.

Result:

REPT Function in Excel 2

previous-small REPT Function in Excel                                                                                                         next_small REPT Function in Excel