How can I separate this string of numbers into separate groups of 3 digit numbers

Question

I have 3 strings of numbers I would like to separate and make into 3 digit number groups.  I also want to move a number to the end in one string and two digits to the end in another string.  I will be adding new numbers each time to rows 2 -  4 and 6 column B

After they get separated like above I wish to take it one step further and break them out into their own cells like below.  Is this possible

Perhaps it can look something like this

Answer 1

This may help you for sure -

note down  numbers series 1 4 7 ...drag it further to automatically fill it.

above it, use formula - =MID($B$2,B5,3)  and drag it further to copy it automatically.

see image 1

Image 1:

Now,

Copy the data and paste it in values and transpose it.

then use the below formula - left, mid & right as shown in image 2.

Image 2:

This will atleast make your work easier. Please let me know if i can help you further.

Thanks,

Praveen

Answer 2

Here is a direct formula that you can use (requires no helper cells). Assuming your first value is in cell A1, put this formula in the first output cell and copy it across two more cells to the right, then select those three cells and copy down until all blanks are output...

=MID($A$ 1,3*ROWS(A$1:A1)+COLUMNS($B1:B1)-3,1)

For you next cell, copy the same formula above into the output cell for that set of numbers, but change the first argument to the absolute address for next cell (do not touch any of the other references) and perform the same copy process as above.

Answer 3

Is there a way to get rid of any duplicates that it may have in it ( example 234 234)

I assume you mean the digits 2-3-4 would be in three separate, adjacent columns, not simply somewhere arbitrarily in the long string of digits, correct? I do not believe that would be possible using formulas (or, if it is possible, such a formula would be large and ugly); however, it can be done using VBA code, but such code would replace the formula method completely. If you absolutely need such functionality, and if you can make use of VBA code in your workbook, let me know and I will try to develop such a VBA solution for you.

Rick,

These are my steps that I take and what ever I can do within a Macro would be FANTASTIC because it is very time consuming to copy and paste all the data and sort it into columns and rows.  If you look at the very first post I start with 881

1)  Paste the data in B:2 881.431009727919581624773191062370305904717895794684262693389860231776157431507154828780520474137937454600348884547522061........

2)  Take the left end single digit (the bold 8) cut it and paste it to the far right end and then paste the new number  and remove decimal point between the 1 and 4 (814310097279195816247731910623703059047178957946842626933898602317761574315071548287805204741379374546003488845475220618)   string in B:4

3)  Take the new far left digit which happens to be another 8 (in bold) and cut it and paste it to the far right end and then paste the new number     (14310097279195816247731910623703059047178957946842626933898602317761574315071548287805204741379374546003488845475220618 8) string in B:6

Then I would put them in their own cell like we are doing now.  After I do that I break them up into 3x3 cubes or 3x4 cubes and get rid of any duplicates that may be in the set of 3 or 4 digits in any combination.  The 3x3 will have 9 digits and the 3x4 will have 12 digits  If a row has 1234 and another has 4231      I delete one of them.

What ever steps I can get help with in a Macro is much appreciated to save a lot of time

Thanks