年月 取出 (9537)

C2=MID(B2,FIND("年",B2)-4,4)&"-"&SUBSTITUTE(MIDB(B2,FINDB("月",B2)-2,2)," ",0)

另解=MID(B2,FIND("年",B2)-4,4)&"-"&LOOKUP(1,0/FIND("年"&ROW($1:$12)&"月",B2),TEXT(ROW($1:$12),"00"))

另解=REPLACE(SUM(MIDB(B2,FINDB({"年","月"},B2)-{4,2},{4,2})*{100,1}),5,,"-")