Excel Question - Pick 3 & 4 Boxed Combos

[Winalot2007]

Is there an easy formula for creating boxed Pick 3 and Pick 4 combos.

For example, in cell a1 I have an actual Pick 3 combo of 076. What formula would work in cell b1. Cell b1 = 067

Also, Pick 4 also if possible.

Thanks

 

[GillesD]

All Pick 3 combinations

If in cell A1, you have your 3 number combination in string form (like ="123"), then in cells A2 to A6, place the following formulas to get the other 5 permutations with your 3 numbers:

- In A2: =LEFT(A1;1)&RIGHT(A1;1)&MID(A1;2;1)
- In A3: =MID(A1;2;1)&LEFT(A1;1)&RIGHT(A1;1)
- In A4: =MID(A1;2;1)&RIGHT(A1;1)&LEFT(A1;1)
- In A5: =RIGHT(A1;1)&LEFT(A1;1)&MID(A1;2;1)
- In A6: =RIGHT(A1;1)&MID(A1;2;1)&LEFT(A1;1)

This will give you respectively 132, 213, 231, 312 and 321, allways in string form. If you want the result as a value, just add +0 at the end of each formula.