型号:分析数据可知,型号一般以'#'或字母开头,长度在8-12字符。先找“#”这处理,字母开头处理很复杂要分步公式处理,因为有26个字母有大小但结果正确,型号都是在类别这后两个“,”之间,如果在前面无“#'”结果会显示“不详”,需要手工处理。用公式: =IF(ISERROR(IF(ISERROR(FIND("#",A2,1)),MID(A2,FIND(",",A2,FIND(E2,A2,1))+1,FIND(",",A2,FIND(",",A2,FIND(E2,A2,1))+1)-FIND(",",A2,FIND(E2,A2,1))-1),MID(A2,FIND("#",A2,1),FIND(",",A2,FIND("#",A2,1)+1)-FIND("#",A2,1)))),"不详",IF(ISERROR(FIND("#",A2,1)),MID(A2,FIND(",",A2,FIND(E2,A2,1))+1,FIND(",",A2,FIND(",",A2,FIND(E2,A2,1))+1)-FIND(",",A2,FIND(E2,A2,1))-1),MID(A2,FIND("#",A2,1),FIND(",",A2,FIND("#",A2,1)+1)-FIND("#",A2,1))))
|