COLUMN B Formula : =IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))=0,A2,IFERROR(LEFT(A2,FIND(" ",A2,1)-1),"")) COLUMN C Formula : =IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=2,IFERROR(MID(A2,FIND(" ",A2,1)+1,(FIND(" ",A2,FIND(" ",A2,1)+1)-FIND(" ",A2,1)-1)),""),IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=1,MID(A2,FIND(" ",A2,1)+1,LEN(A2)-FIND(" ",A2,1)+1-1),"")) COLUMN D Formula : =IFERROR(IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=3,MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))-1-FIND(" ",A2,FIND(" ",A2,1)+1)),MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1,LEN(A2)-FIND(" ",A2,1)+1-1)),"") COLUMN E Formula : =IFERROR(IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=4,MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1)-FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))-1),MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1,LEN(A2)-FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1)),"") COLUMN F Formula : =IFERROR(MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1)+1,LEN(A2)-FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1)+1),"") =================================================================================================================== TO GET ALL SEPARATED TEXT IN SINGLE CELL FORMULA: =IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))=0,A2,IFERROR(LEFT(A2,FIND(" ",A2,1)-1),""))&" "&IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=2,IFERROR(MID(A2,FIND(" ",A2,1)+1,(FIND(" ",A2,FIND(" ",A2,1)+1)-FIND(" ",A2,1)-1)),""),IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=1,MID(A2,FIND(" ",A2,1)+1,LEN(A2)-FIND(" ",A2,1)+1-1),""))&" "&IFERROR(IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=3,MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))-1-FIND(" ",A2,FIND(" ",A2,1)+1)),MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1,LEN(A2)-FIND(" ",A2,1)+1-1)),"")&" "&IFERROR(IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=4,MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1)-FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))-1),MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1,LEN(A2)-FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1)),"")&" "&IFERROR(MID(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1)+1,LEN(A2)-FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2,1)+1))+1))+1)+1),"")