In one cell of a csv file there are 5 sets of numbers separated by a space. I need a formula that can pull these numbers out and each given a cell

[Ez00l]

In one cell of a .csv file there are 5 sets of numbers separated by a space between each number. Each number is 2 characters. I need a formula that can pull these numbers out and each given its own cell. After that, I will need to get counting of times each number is in that column. Ultimately, I will use this information as a prefixes in another spread sheet.

Thank you in advance for any advice or suggestions given!

 

[jtakw]

Hi,

Use C2 formula, result is Text for cases where there may be leading 0 you want to preserve.
OR use C3 formula, result is converted to Real Numbers.

Book3.xlsx
	A	B	C	D	E	F	G
1
2		10 22 08 92 88	10	22	08	92	88
3		11 22 08 92 88	11	22	8	92	88
Sheet958

Cell Formulas
Range	Formula
C2:G2	C2	=TRIM(MID(SUBSTITUTE(" "&$B2," ",REPT(" ",100)),COLUMNS($C2:C2)*100,100))
C3:G3	C3	=MID(SUBSTITUTE(" "&$B3," ",REPT(" ",100)),COLUMNS($C3:C3)*100,100)+0

 

[SpillerBD]

Legacy Import with Delimiters of both Comma and Space?