Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Pull Each Each Digit From Number Into Single Cells

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Pull Each Each Digit From Number Into Single Cells

    Hi excel expert

    Attached is the sample file.

    Basically I have a number in column A, just wondering is that any faster to allocate the number into individual cell as shown in the attached file.

    Regards
    Attached Files

  • #2
    Re: Link Number Into Individual Cell

    Hi,

    May be..

    In C3 and copied down & across,

    =IF(COLUMNS($C3:C3)>LEN(REPT("0",9-LEN(SUBSTITUTE(TEXT($A3,"#.00"),".","")))),MID(REPT("0",9-LEN(SUBSTITUTE(TEXT($A3,"#.00"),".","")))&SUBSTITUTE(TEXT($A3,"#.00"),".",""),COLUMNS($C3:C3),1),"")

    Note: Formula edited 1 time
    Kris

    ExcelFox

    Comment


    • #3
      Re: Pull Each Each Digit From Number Into Single Cells

      Here's another alternative.

      Set up an named array constant called Arr which is defined as:
      ={1,2,3,4,5,6,7,8,9}

      Then select cells C3:K3 and complete this array range formula with CTRL+SHIFT+ENTER:
      =MID(TEXT($A3,"0.00"),(SUBSTITUTE(SMALL((ISNUMBER(-(MID(TEXT($A3,"0.00"),Arr,1)))*Arr),Arr),0,LEN(TEXT($A3,"0.00"))+1)),1)

      Then fill the formula down the table.

      Example attached.

      Colin
      Attached Files

      Comment


      • #4
        Re: Pull Each Each Digit From Number Into Single Cells

        Very nice and interesting formulas Kris n Colin.

        Comment


        • #5
          Re: Pull Each Each Digit From Number Into Single Cells

          If anyone wants a breakdown on how the formula works then I would be happy to oblige...

          Colin

          Comment


          • #6
            Re: Pull Each Each Digit From Number Into Single Cells

            Here's another option:

            =IF(LEN(100*$A3)<12-COLUMN(),"",MID(TEXT(100*$A3,"000000000"),COLUMN()-2,1)+0)
            Entia non sunt multiplicanda sine necessitate.

            Comment


            • #7
              Re: Pull Each Each Digit From Number Into Single Cells

              Could you please explain what will be the Formula for Extracting 15 Digit ? Thanks ! - Sreenivas

              Comment


              • #8
                Re: Pull Each Each Digit From Number Into Single Cells

                Welcome to the forum, sreenivasr.

                Please do not post questions in threads started by other members. Start your own thread, give it a clear and concise title and explain your problem fully.

                If this thread can help explain your issue, you can include a link by copying the URL from the address bar of your browser and pasting into your message.

                Thank you.

                Comment

                Trending

                Collapse

                There are no results that meet this criteria.

                Working...
                X