Rept() function in excel repeat the given text, the specified number of times. Use this function to fill a cell with a number of instances of a text string. Syntax: rept(text, number_of_times). Eg. rept("a",3) returns the value "aaa" in the cell where this function is given. The number_of_times must be a positive integer.