COLUMN B Formula : =IF(LEN(A3)-LEN(SUBSTITUTE(A3,",",""))=0,A3,IFERROR(LEFT(A3,FIND(",",A3,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),"")