EXCEL如何将门牌号如“五层11号”转换为数字“511”?答:=VLOOKUP(A1,IF({1,0},TEXT(INT(ROW($101:$999)%),"[DBNum1]")&"层"&MOD(ROW($101:$999),100)&"号",ROW($101:$999)),2,)或者 =MAX(IFERROR(IF(LEFT(A1)=TEXT(INT(ROW($1:$9)),"[DBNum1]"),ROW($1:$9))/1%+MID(A1,3,{1,2}),))都是数组公式,三键结束 ...