如题所述
A3=IF($B3="",0,IF($B3="ç»å°¾",RIGHT($A$1,LEN($A$1)-$B2),MID($A$1,$B2+1,$B3-$B2-1)))
B3=IF(OR($B2="ç»å°¾",$B2=""),"",IF(ISERROR(SEARCH(",",$A$1,B2+1)),"ç»å°¾",SEARCH(",",$A$1,B2+1)))
A2=LEFT($A$1,B$2-1) B2=SEARCH(",",$A$1)