On Jan 11, 4:53*pm, Fion wrote:

For example, the cell I need to repeat is A1 ie MS, the number of times to
repeat is 20 times ie B1 and the result in column C, ie automatically filled
with 20 cells of MS.
Is there any formula to do this?

*A1 * *| *B1 * | *C1 *|
-----------------------------
MS * * | *20 * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|
* * * * *| * * * * | *MS *|


You could enter following formula in C1 and then drag it down as far
as you need it:
(assuming, that you want to start in the first row!)

=IF(ROW()<=$B$1,$A$1,"")

hth

Carlo