=LEFT(A1,FIND(" ",A1,1)-1)*1

=MID(A1,FIND(" ",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3




"swati" wrote:

I have some data in a column that i need to split in 2 colums. eg..
column a
10 apples
5 peaches
7 books

have to make it like :
column a column b
10 apples
5 peaches
7 books

any way i can do tht?