如何将excel某单元格中的长宽高,单独的提取到某一行。答:看下边例子,B2公式为=TRIM(MID(SUBSTITUTE($A2,"*",REPT(" ",99)),COLUMN(A2)*100-99,99)),数组公式,三键结束,横向拖动公式得到宽与高,下拉计算其他数据。再列举一种情况,看下图,B1公式=-LOOKUP(1,-MID($A2,FIND(B$1,$A2)+1,ROW($1:$9)))。
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:...