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

 

[Skyybot]

Are you looking for a VBA solution, or a Formula solution?

 

[rebel123]

Looking for a formula solution....

Also, in my example, I put my answers into 4 columns.
I would not care if the answers are all in 1 column, which is what I was
going to do anyway.

 

[Kerryx]

maybe something like

Book1
	A	B	C	D	E
1	123	123
2	1234		1234
3	12345			12345
4	456	456
5	456789				456789
6	345	345
7	567	567
8	78901			78901
9	789	789
Sheet1

Cell Formulas
Range	Formula
B1:E9	B1	=IF(LEN($A$1:$A$9)=TRANSPOSE(UNIQUE(LEN($A$1:$A$9))),$A$1:$A$9,"")
Dynamic array formulas.

 

[rebel123]

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!

 

[Skyybot]

I just want to make sure that I understand the result that you are looking for: You have a column with a bunch of different length numbers; you want to have a column the has the results "There are 16 instances of an 8 digit number" and "There are 4 instances of a 16 digit number" and so on and so on? Is this correct?

 

[Fluff]

I uploaded the sample
excel file.

I will not download that file as the site has been reported for phishing attacks.

 

[Skyybot]

I think Power Query is going to be your answer.

 

[rebel123]

whats a better site for me to upload the file?

 

[Fluff]

How about OneDrive, GoogleDrive or DropBox