how I can divide a sum number into 50 column in ecxel?

I would like to tell, with a smaller number of columns. Let's say we have a sum of 24 and we want to distribute it randomly into 10 separate columns. we should get such a result as below I wrote.

enter image description here

Is there a formula in Excel like this?

Thanks in advance.