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个空格,这样的目的是将各数字段分隔的远...
excel表格操作求助,如图1,怎么把C列内容随着B列与A列匹配,最后变成如图2...答:在E,F列实现,在E1里:=IF(F1="","",A1),F1里:=IFERROR(VLOOKUP(A1,$B$1:$C$5,2,0),"") ,然后E1和F1的公式拉下来,具体见附件