提取文字後数字 (9713)


D3:I7=IFERROR(-LOOKUP(9,-MID($B3,FIND(D$2,$B3)+LEN(D$2),ROW($1:$9))),"")


另解=IFERROR(LEFT(SUBSTITUTE(MID($B3,FIND(D$2,$B3)+LEN(D$2),9),"、",REPT(" ",9)),9)*1,"")


留言