Rept Function In Excel

Rept Function In Excel Coursedots.blogspot.com

 
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

Syntex:

=REPT(TextToRepeat,Repetitions)
The maximum number of repetitions is 200

Formatting

No Special formatting is needed

Note

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.






EmoticonEmoticon