/blogentry/51816 time*treat's Blog: Splitting P3/P4 numbers en-us Lottery Post RSS Generator /blogentry/51816 /blogentry/51816 Sun, 27 Feb 2011 19:09:36 GMT time*treat To split a p3 or p4 number into component parts

P3: full number in cell A1: e.g. 234

formula in B1: = INT(A1/100)

formula in C1: = INT(MOD(A1,100)/10)

formula in D1: = MOD(A1,10)

P4: full number in cell A3: e.g. 4321

formula in B3: = INT(A3/1000)

formula in C3: = INT(MOD(A3,1000)/100)

formula in D3: = INT(MOD(A3,100)/10)

formula in E3: = MOD(A3,10)

____ A B C D E

1 234 2 3 4

2

3 4321 4 3 2 1

4 ____ ____ ____ ____ ____

]]> Blog Entry time*treat https://www.lotterypost.com/blogentry/51816