如图:建一个车型库(G1:G3)

B1=MID(A1,1,MIN(IF(ISNUMBER(FIND($G$1:$G$3,A1)),FIND($G$1:$G$3,A1),4^8)-1))

C1=INDEX($G$1:$G$3,MIN(IF(ISNUMBER(FIND($G$1:$G$3,A1)),ROW($1:$3),4^8)))

数组公式

D1=MID(A1,FIND(C1,A1)+LEN(C1),100)