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中怎么把括号中的数字提取出来?答:在B1输入公式右拉即可,公式一需要EXCEL2007开始支持,公式二长点,但EXCEL 2007以下的版本都可以用。如图 公式一: =IFERROR(--TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,"(",REPT(" ",50)),")",REPT(" ",50)),COLUMN(A1)*100-50,50)),"")公式二:=IF(COLUMN(A1)>SUM(N(MID($A1,ROW($...