="{"&SUBSTITUTE(REPT(A1&", ",B1),",","",B1)&"}"

"liups" wrote:

Hi,
I need to repeat the content of a cell to form an array, like this:
A1: 100
B1: 3
I want to put in C1 an array like this :{100, 100, 100}, but I don't
know how to write the formula, any ideas?

thank you very much.