separate a number with hyphens into singles?

[excelNewbie22]

hi!
i need to separate a number like this 1-4-7-10-22-33 into separate cells, 1 4 7 10 22 33
and i've already know how to do so with excel,
but sometimes a formula will be quicker way,
and found several in google but didn't found one that will separate the number without the hyphens too,
anyone?

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G
1	1-4-7-10-22-33	1	4	7	10	22	33
Sheet2

Cell Formulas
Range	Formula
B1:G1	B1	=TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",99)),SEQUENCE(,6,,99),99))
Dynamic array formulas.

 

[excelNewbie22]

thanks eric!