判斷 英文或数字 (10522)

C2:E10=IF((COLUMN(A1)>LEN($B2)-LEN(SUBSTITUTE($B2,"/",))+1)+(COLUMN(A1)=1),"","/")&IFERROR(TEXT(-(0&INDEX(LEFT(TRIM(MID(SUBSTITUTE($B2,"/",REPT(" ",99)),{1,2,3}*99-98,99))),COLUMN(A1))),";食品;"),"文具")&D2