Welcome Guest
You last visited December 11, 2016, 12:58 am
All times shown are
Eastern Time (GMT-5:00)

Excel Help needed

Topic closed. 4 replies. Last post 6 years ago by Raven62.

 Page 1 of 1
NASHVILLE, TENN
United States
Member #33372
February 20, 2006
1044 Posts
Offline
 Posted: November 16, 2010, 5:56 pm - IP Logged

I have a four digit number in a cell.  I wish to break that four digit number down into four individual digits, putting each individual digit in it's own column/cell.  I know there is a formula for this but I can't seem to find it.  Will anyone help me?

Thanks

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5913 Posts
Offline
 Posted: November 16, 2010, 6:15 pm - IP Logged

Don't know what Excel version you have, but try TEXT to Columns!

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: November 16, 2010, 7:03 pm - IP Logged

I have a four digit number in a cell.  I wish to break that four digit number down into four individual digits, putting each individual digit in it's own column/cell.  I know there is a formula for this but I can't seem to find it.  Will anyone help me?

Thanks

If your Pick 4 Combination is in cell E20

Place this formula in cell K20  =INT(E20/1000)

Place this formula in cell L20  =INT((E20-(K20*1000))/100)

Place this formula in cell M20  =INT((E20-((K20*1000)+(L20*100)))/10)

Place this formula in cell N20  =INT((E20-((K20*1000)+(L20*100)+(M20*10))))

Iron Station, NC
United States
Member #74828
May 21, 2009
69 Posts
Offline
 Posted: November 16, 2010, 7:23 pm - IP Logged

If the numbers have a space, comma, tab are something separating them click on the Data ribbon

then text to column, read and pick out the information needed for your number, separated by ??

Click next until you get each number in a separate column. Work with it, it’s the easiest way to do

what you want

New Jersey
United States
Member #17843
June 28, 2005
49835 Posts
Offline
 Posted: November 16, 2010, 10:19 pm - IP Logged

I have a four digit number in a cell.  I wish to break that four digit number down into four individual digits, putting each individual digit in it's own column/cell.  I know there is a formula for this but I can't seem to find it.  Will anyone help me?

Thanks

Lottery Post Forums Search is Your Friend: