How to split text & numbers in one cell to multiple cells

Hi all,

I need to split text in one cell to multiple cells. the text contains numbers as well & in fact the starting character within the cell is a number.

see attached file & kindly provide solution

Thanks

Could you supply more rows of sample?

or just simly use "Text to column" for ur given example

Text to column-----------fixed width

Originally Posted by udprocks

or just simly use "Text to column" for ur given example

Text to column-----------fixed width

It doesn't work because the columns are not of fixed width!

Originally Posted by AliGW

It doesn't work because the columns are not of fixed width!

yes, ali but that was for that first given example file.

Originally Posted by AliGW

It doesn't work because the columns are not of fixed width!

yes, ali but that was for that first given example file sorry.

Originally Posted by udprocks

yes, ali but that was for that first given example file sorry.

Yes, and it didn't work with that file, either!!! What would need to be in the second column were of different lengths.

Ok Let try

C6=LEFT(A6,FIND(" ",A6)-1)
D6=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A6,E6,""),F6,""),G6,""),H6,""),C6,""))
E6=IFERROR(TRIM(RIGHT(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A6,F6," "),G6," "),H6," "))," ",REPT(" ",50)),50)),0)
F6=IFERROR(-LEFT(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A6,"-",REPT(" ",50)),50))," ",REPT(" ",50)),50),0)
G6=IFERROR(TRIM(LEFT(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A6,"-",REPT(" ",50)),ABS(F6),REPT(" ",50)),50))," ",REPT(" ",50)),50)),0)
H6=IFERROR(TRIM(RIGHT(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A6,"-",REPT(" ",50)),ABS(F6),REPT(" ",50)),50))," ",REPT(" ",50)),50)),0)

and drag down