=IF(ISNUMBER(FIND("年",A2)),MATCH(LEFT(A2,FIND("年",A2)-1),SUBSTITUTE(TEXT(ROW($1:$50),"[DBNum1]"),"一十","十"),)&"年",)&IF(ISNUMBER(FIND("个月",A2)),MATCH(SUBSTITUTE(RIGHT(SUBSTITUTE(A2,"个月",),2),"年",),SUBSTITUTE(TEXT(ROW($1:$50),"[DBNum1]"),"一十","十"),)&"个月",)
=IF(ISNUMBER(FIND("年",A2)),MATCH(LEFT(A2,FIND("年",A2)-1),SUBSTITUTE(TEXT(ROW($1:$50),"[DBNum1]"),"一十","十"),),)*12+IF(ISNUMBER(FIND("个月",A2)),MATCH(SUBSTITUTE(RIGHT(SUBSTITUTE(A2,"个月",),2),"年",),SUBSTITUTE(TEXT(ROW($1:$50),"[DBNum1]"),"一十","十"),),)
都是数组公式
太长了,将就用吧。