In this video, I have informed..
Rept Formula, Rept Function
how we can repeat particular text in single cell?
Repeat Text, Symbols, Numbers etc.
Description
Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.

Syntax
REPT(text, number_times)

The REPT function syntax has the following arguments:

Text Required. The text you want to repeat.

Number_times Required. A positive number specifying the number of times to repeat text.

Remarks
If number_times is 0 (zero), REPT returns "" (empty text).

If number_times is not an integer, it is truncated.

The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!.

By this function you can repeat your data how many times you want.
Introduction and practical examples of REPT function in Excel. The syntax for this function: =REPT(“*”,5);
Follow me on other planform also:

Facebook - [ Ссылка ]
Instagram - [ Ссылка ]
Twitter - [ Ссылка ]
#Excel #ReptFormula #ReptFunction

свернуть