Welcome Guest
( Log In | Register )
The time is now 12:28 pm
You last visited February 14, 2012, 11:24 am
All times shown are
Eastern Time (GMT-5:00)
Update your time zone

Comments for "Pick 3 - Pick 4 - Pick 5 - Pick 6 Excel Formulas"

April 30, 2010, 10:59 pmPick 3 - Pick 4 - Pick 5 - Pick 6 Excel Formulas

Pick 3, Pick 5, Pick 5, and Pick 6 combinations to separate cells - formulas

Entry #152
Subscribe to comments posted here

Comments

1.
Comment by winsumloosesum - April 30, 2010, 11:04 pm
123 (in cell A2)
=INT(A2/100)
=INT((A2-(B2*100))/10)
=INT((A2-((B2*100)+C2*10)))
=========================
1234 (In Cell A4)
=INT(A4/1000)
=INT((A4-(B4*1000))/100)
=INT((A4-((B4*1000)+(C4*100)))/10)
=INT((A4-((B4*1000)+(C4*100)+(D4*10))))
==================================
12345 (In cell A5)
=INT(A6/10000)
=INT((A6-(B6*10000))/1000)
=INT((A6-((B6*10000)+(C6*1000)))/100)
=INT((A6-((B6*10000)+(C6*1000)+(D6*100)))/10)
=INT((A6-((B6*10000)+(C6*1000)+(D6*100)+(E6*10))))
============================================
123456 (In cell A8)
=INT(A8/100000)
=INT((A8-(B8*100000))/10000)
=INT((A8-((B8*100000)+(C8*10000)))/1000)
=INT((A8-((B8*100000)+(C8*10000)+(D8*1000)))/100)
=INT((A8-((B8*100000)+(C8*10000)+(D8*1000)+(E8*100)))/10)
=INT((A8-((B8*100000)+(C8*10000)+(D8*1000)+(E8*100)+(F8*10))))
=========================================================

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.