Automatic combination of 3 numbers

[carduel]

Hello,

Whether it is possible to enroll all combinations of 3 group numbers in Excel ? For example , numbers 1,2,3 are 27 possible combinations.

1 1 1
1 1 2
1 1 3
1 2 1
1 2 2
1 2 3

etc...

Thanks.

[mikeTRON]

VBA could do it but I wouldnt bother with excel formulas.