(先)D2:D9=IF(ISERR(FIND("/",A2)),"","/"&TRIM(MID(SUBSTITUTE(A2,"/",REPT(" ",99)),99,99))&"/")
(二)C2:C9=IF(D2="","",LOOKUP(1,0/(RIGHT(MID(A2,FIND(D2,A2)+LEN(D2)+1,{1,2,3,4}))="."),MID(A2,FIND(D2,A2)+LEN(D2)+1,{1,2,3,4})))
(三)B2:B9 {=TRIM(IF(D2="",MID(A2,MATCH(1=1,MIDB(A2,ROW($1:$39),2)=" ",)-1+(D2=""),99),MID(SUBSTITUTE(A2,D2&" "&C2,REPT(" ",99)),99,99)))
(四)E2:E9=TRIM(LEFT(SUBSTITUTE(A2,IF(C2="",B2,D2),REPT(" ",99)),99)) |