REPEAT function

Category:Text

Name in English:REPT

That makes?

Repeat a text a specified number of times.

Syntax

REPEAT (text, num_of_times)

  • text (required ): The text (or character) to be repeated.
  • num_of_times (required ): The number of times the text will be repeated.

Examples

REPEAT (“Excel”, 2) = “ExcelExcel”
REPEAT (“@”, 3) = “@@@”

Leave a Comment