含 A 提取字符串 (1013)

B2:E9{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE($A2,",",REPT(" ",99)),ROW($1:$5)*99-98,99)),SMALL(IF(1-ISERR(FIND("A",MID(SUBSTITUTE($A2,",",REPT(" ",99)),ROW($1:$5)*99-98,99))),ROW($1:$5)),COLUMN(A1))),"")