Cell  Formula  B1  =LEFT(A1, FIND(";", A1)1)  C1  {=MID(";"&A1&";",FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))+1,FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($2:$7)))FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))1)}  B2  =MID(A1,1+FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),1)),FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),2))FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),1))1)  C2  {=MID(";"&A1&";",FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))+1,FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($2:$7)))FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))1)}  B3  =MID(A1,1+FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),2)),FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),3))FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),2))1)  C3  {=MID(";"&A1&";",FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))+1,FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($2:$7)))FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))1)}  B4  =MID(A1,1+FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),3)),FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),4))FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),3))1)  C4  {=MID(";"&A1&";",FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))+1,FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($2:$7)))FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))1)}  B5  =MID(A1,1+FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),4)),FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),5))FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),4))1)  C5  {=MID(";"&A1&";",FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))+1,FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($2:$7)))FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))1)}  B6  =RIGHT(A1,LEN(A1)FIND(CHAR(201),SUBSTITUTE(A1,";",CHAR(201),LEN(A1)LEN(SUBSTITUTE(A1,";","")))))  C6  {=MID(";"&A1&";",FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))+1,FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($2:$7)))FIND("`",SUBSTITUTE(";"&A1&";",";","`",ROW($1:$6)))1)} 

Like this thread? Share it with others