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

 

[Fluff]

How about OneDrive, GoogleDrive or DropBox

 

[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

 

[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