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

Follow the steps in the link and check if that helps.

http://www.mrexcel.com/forum/excel-questions/443983-extract-only-numbers-text-string.html

Answer 4

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

Thanks Praveen works like a charm and easy, now for step two in another post (-:

Answer 5

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

Thanks Praveen works like a charm and easy, now for step two in another post (-:

I am glad that it helped you. U can surely tell me in case of any kind of help related to excel.. :) enjoy!