The function Rept repeats a text string a given number of times in the selected cell.
Syntax:
=Rept ( text string to repeat, number of times)
Text string. Can be a text string in quotations marks or a cell reference that contain the text string you want to repeat.