• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Breaking down values

shinz

New Member
Hi, I got a question regarding breaking down values and i would love to get some help.

Say i have these values (the values are random)

98505
64150
1155
645131
15411
...
...
and so on

i would like to break down those values to
Cell A1 Cell B1 Cell C1
9 85 5
6 41 50
11 55
64 51 31
1 54 11
...
...

hope i show it pretty clear above. Thanks in advance!
 
Can you explain a little more coz you had a number with the length of 4 and the formula is splitting it as you had asked for,1155 to 11 and 55. If you want to test the formula further please upload more numbers...
 
Can you explain a little more coz you had a number with the length of 4 and the formula is splitting it as you had asked for,1155 to 11 and 55. If you want to test the formula further please upload more numbers...

2hpp01w.jpg


sorry the text got mixed up when i post.
 
Back
Top