EXCEL迷

D2:G7{=IFERROR(SUBSTITUTE(TRIM(VLOOKUP("*"&D$1&"*",MID(SUBSTITUTE($B2,"/",REPT(" ",99)),ROW($1:$9)*99-98,99),1,)),D$1,),"")

另解=IFERROR(LEFT(MID($B2,FIND(D$1,$B2)+LEN(D$1),99),FIND("/",MID($B2,FIND(D$1,$B2)+LEN(D$1),99)&"/")-1),"")

另解=IFERROR(TRIM(LEFT(SUBSTITUTE(MID($B2,FIND(D$1,$B2)+LEN(D$1),99),"/",REPT(" ",99)),99)),"")