excel怎么样提取有数字单元格对应行和列的内容答:J2=INDIRECT(TEXT(SMALL(IF($B$2:$G$16<>"",ROW($B$2:$G$16)*100+1,4^8),ROW(A1)),"r0c00"),)&INDIRECT(TEXT(MOD(SMALL(IF($B$2:$G$16<>"",ROW($B$2:$G$16)*100+COLUMN($B$2:$G$16),4^8),ROW(A1)),100)+100,"r0c00"),)&INDIRECT(TEXT(SMALL(IF($B$2:...
Excel操作,提取某一单元格的中间两位数字,并以改提取数字另外加文字的形...答:=IF(OR(--MID(A2,3,1)=0,--MID(A2,5,1)=0),LEFT(A2,2)&"级"&MID(A2,4,1)&"班"&RIGHT(A2,1)&"号",LEFT(A2,2)&"级"&MID(A2,3,2)&"班"&RIGHT(A2,2)&"号")