|
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.
|