C2=TRIM(MID(SUBSTITUTE(A2,"-",REPT(" ",99)),MATCH(1,MMULT(1-ISERR(FIND({"DN","NPS"},MID(SUBSTITUTE(A2,"-",REPT(" ",99)),ROW($1:$9)*99-98,99))),{1;1}),)*99-98,99))
另解=TRIM(LOOKUP("做",MID(SUBSTITUTE(A2,"-",REPT(" ",99)),FIND({"DN","NPS"},SUBSTITUTE(A2,"-",REPT(" ",99))),99)))
留言
張貼留言