Welcome Guest
Log In | Register )
You last visited December 4, 2016, 5:20 pm
All times shown are
Eastern Time (GMT-5:00)

Formula help

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

Page 1 of 1
PrintE-mailLink
frenchie's avatar - Lottery-041.jpg
Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
Posted: July 3, 2010, 5:53 pm - IP Logged

Hi,

        I need help with a formula that will extract digits from a 8 digits number ?

Exemple I have in cell : A1 the number : 15624298 and I need a formula or formulas that will put each digit in different cell ? thank you.

A1 : 15624298

will result in cells :

B1 : 1

C1 : 5

D1 : 6

E1 : 2

F1 : 4

G1 : 2

H1 : 9

 I1 : 8

                                                                         Thank you.            Frenchie.

    CARBOB's avatar - FL LOTTERY_LOGO.png
    ORLANDO, FLORIDA
    United States
    Member #4924
    June 3, 2004
    5893 Posts
    Offline
    Posted: July 3, 2010, 6:16 pm - IP Logged

    Hi,

            I need help with a formula that will extract digits from a 8 digits number ?

    Exemple I have in cell : A1 the number : 15624298 and I need a formula or formulas that will put each digit in different cell ? thank you.

    A1 : 15624298

    will result in cells :

    B1 : 1

    C1 : 5

    D1 : 6

    E1 : 2

    F1 : 4

    G1 : 2

    H1 : 9

     I1 : 8

                                                                             Thank you.            Frenchie.

    Put cursor in A1, find Text to Columns menu, usually it's under the data menu.

      frenchie's avatar - Lottery-041.jpg
      Los Angeles
      United States
      Member #75410
      June 2, 2009
      479 Posts
      Offline
      Posted: July 3, 2010, 6:34 pm - IP Logged

      Thanks CARBOB,

         I tried but it doesn't work,


       I realy NEED A FORMULA for this one, I need the number to stay as a number and not a text.

          I know someone out there has the answer !!!  Thanks again CARBOB.

        JADELottery's avatar - MeAtWork 03.PNG
        The Quantum Master
        West Concord, MN
        United States
        Member #21
        December 7, 2001
        3675 Posts
        Offline
        Posted: July 3, 2010, 7:30 pm - IP Logged

        This should work provided it's used for 8 digit numbers only.

        Play around with it and you can get it for other digit sizes.

        If the data is in A1, first paste this into B1.

        After that, copy contents of B1 and paste into the other cells.

        Excel will handle the column and row changes automagically.

         

        =VALUE(MID(TEXT($A1,"00000000"),CELL("col",B1)-CELL("col",$A1),1))

        Presented 'AS IS' and for Entertainment Purposes Only.
        Any gain or loss is your responsibility.
        Use at your own risk.

        Order is a Subset of Chaos
        Knowledge is Beyond Belief
        Wisdom is Not Censored
        Douglas Paul Smallish
        Jehocifer

          frenchie's avatar - Lottery-041.jpg
          Los Angeles
          United States
          Member #75410
          June 2, 2009
          479 Posts
          Offline
          Posted: July 3, 2010, 10:32 pm - IP Logged

          Thank you very much JADELottery, it work perfectly.                 

                                                                                                                                                 Serge.