Welcome Guest
Log In | Register )
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
PrintE-mailLink
Avatar
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

    CARBOB's avatar - FL LOTTERY_LOGO.png
    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!

      winsumloosesum's avatar - Lottery-060.jpg
      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))))

        Avatar
        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

          Raven62's avatar - binary
          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:

          http://www.lotterypost.com/thread/106647/327740

          A mind once stretched by a new idea never returns to its original dimensions!