Rept Function In Excel by thememonking
What Does Do It?
This Function repeats a piece of text a specified number of times
You need to specify the text to be repeated and how many times to repeat it
The maximum number of repetitions is 200
No Special formatting is needed
The resulting text string must be no longer than 32,767 characters. if it is longer than this, the Rept function returns the Excel #VALUE! error.