REPT Function in EXCEL SHEET

Let’s assume you needed to replicate a certain symbol over a 1000 times in a single cell. Now, you can Repeats text a given number of times.so a special function is provided by the EXCL.

•   Use REPT to fill a cell with a number of instances of a text string.

Syntax Of REPT

=REPT(text, number_times) 

 Where,

• ‘text’ is the text that you intend to repeat and
•  The ‘number_of-times’ is a positive number specifying the number of times the text should be repeated.

 YOU CAN SEE DEMO SLIDE BELOW

  
HOPE IT IS HELPFUL FOR YOU.
FOR MORE TIPS OF EXCEL SHEET

• How To Add A Check Box in EXCEL SHEET ?
• What is IF Formula in EXCEL SHEET ?
• How to add drop down list in excel sheet ?