EXCEL表格怎么提取如图的A列的长、宽、高的数值分别反馈到B列、C列...答:=TRIM(MID(SUBSTITUTE(REPLACE($A2,1,FIND(" ",$A2),),"X",REPT(" ",99)),COLUMN(A$1)*99-98,99))向右向下复制公式。先用REPLACE($A2,1,FIND(" ",$A2),)将前面的HT去掉,然后用SUBSTITUTE(100X70X150,"X",REPT(" ",99))将X替换为99个空格,这样的目的是将各数字段分隔的远...