202212021410字母後數字 提取 (10823)

D2:G7{=IFERROR(SUBSTITUTE(TRIM(VLOOKUP("*"&D$1&"*",MID(SUBSTITUTE($B2,"/",REPT(" ",99)),ROW($1:$9)*99-98,99),1,)),D$1,),"")

另解=IFERROR(LEFT(MID($B2,FIND(D$1,$B2)+LEN(D$1),99),FIND("/",MID($B2,FIND(D$1,$B2)+LEN(D$1),99)&"/")-1),"")

另解=IFERROR(TRIM(LEFT(SUBSTITUTE(MID($B2,FIND(D$1,$B2)+LEN(D$1),99),"/",REPT(" ",99)),99)),"")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank