指定ID與姓名後面字符串 取出 (14114)

C2:D6{=SUBSTITUTE(TRIM(MID(SUBSTITUTE(INDEX($A:$A,SMALL(IF(1-ISERR(FIND(C$1&":",$A$2:$A$10)),ROW($2:$10),99),ROW(A1))),",",REPT(" ",99)),COLUMN(A1)*99-98,99)),C$1&":",)