如何把46个月换算成*年*个月 (9023)

C2 (最多99)=TEXT(INT(LEFTB(B2,2)/12),"0年;;")&TEXT(MOD(LEFTB(B2,2),12),"0个月;;")

另解=TEXT(INT(SUBSTITUTE(B2,"个月",)/12),"0年;;")&TEXT(MOD(SUBSTITUTE(B2,"个月",),12),"0个月;;")