Looking at 1 Column and then extracting the same number of characters into separate columns

[rebel123]

The correct answers are attached- I may have put a few in the wrong order but the order does not matter- only the number
of characters. So, the answer is correct. I just need an equals sign equation.

I am extracting the first series of data and then I am putting all of the answers in separate columns
by separating them into separate columns.


File is here

https://file.io/kJ6XFsXjLi6M

Image is attached

 

[rebel123]

OK sorry here is the google link-

Info.xlsx

Sheet1 0201022600000250000000 0201044100040030100000 020104410004017001 020104410004037002 020104410005022 020104500001075 0201045100020380000001 0202052100000160020000 0202082700000040010000 0202082700000120000001 0202082800000060300000 0202082800000070070000 02020828000000706 02020930000000503...

docs.google.com

 

[rebel123]

or this is the onedrive. Not sure if you can download from either link. I dont know how onedrive works.

Info.xlsx

onedrive.live.com

 

[Fluff]

Thanks for that.
For the result in a single column how about

Info.xlsx
	A	B
1	0201022600000250000000	020104410005022
2	0201044100040030100000	020104500001075
3	020104410004017001	020309303000025
4	020104410004037002	02020828000000706
5	020104410005022	02030930300001901
6	020104500001075	02030931100001301
7	0201045100020380000001	020104410004017001
8	0202052100000160020000	020104410004037002
9	0202082700000040010000	0201022600000250000000
10	0202082700000120000001	0201044100040030100000
11	0202082800000060300000	0201045100020380000001
12	0202082800000070070000	0202052100000160020000
13	02020828000000706	0202082700000040010000
14	0202093000000050300000	0202082700000120000001
15	0202093000000050600000	0202082800000060300000
16	0203062300000170010000	0202082800000070070000
17	02030930300001901	0202093000000050300000
18	020309303000025	0202093000000050600000
19	0203093030000620000000	0203062300000170010000
20	02030931100001301	0203093030000620000000
Sheet1

Cell Formulas
Range	Formula
B1:B20	B1	=SORTBY(A1:A20,LEN(A1:A20))
Dynamic array formulas.

 

[rebel123]

cant get it to work do you mind uploading the file

 

[rebel123]

oh nevermind it worked. The reason why it didnt work before was because when I first
started this spreadsheet I changed all of the cells formats to TEXT ONLY.

If you do that (like I did) the formula does not work.

So I opened a new spreadsheet, copied column A and then put your formula in Column B.

Thanks Fluff!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Kerryx]

i tried the formula and it did not work. I may have done it wrong. Another thing you
could do is upload the excel file with the correct results, since I uploaded the sample
excel file.

Although a formula solution is preferred.... a VBA solution would be fine if you upload
the excel file. I have An Apple Computer, so I think I wrote that on my profile.

Many thanks!

See you got sorted , yes if the data was text the formula would not work for you