Welcome Guest
The time is now 11:50 pm
You last visited January 19, 2017, 10:37 pm
All times shown are
Eastern Time (GMT-5:00)

# Pick 3 - Pick 4 - Pick 5 - Pick 6 Excel Formulas

Published:

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

Entry #152

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.