取型號+尺寸 (10659)

C2{=MAX(ISNUMBER(FIND(ROW($1:$999)&{"S","M","L"},A2))*ROW($1:$999))&LOOKUP(1,0/FIND({"S","M","L"},A2),{"S","M","L"})

另解=LOOKUP(9^9,--RIGHT(LEFT(A2,MIN(FIND({"M","S","L"},A2&"MSL"))-1),ROW($1:$102)))&MID(A2,MIN(FIND({"M","S","L"},A2&"MSL")),1)