如何提取出表格第一列中的数字出来,到第二列?答:1.提取中文 =LEFT(SUBSTITUTE(A1," ",),LENB(SUBSTITUTE(A1," ",))-LEN(SUBSTITUTE(A1," ",)))2.提取数字 =MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),65536)
excel表格中提取自身文件名后,怎么样在两个表格中分别显示文字与数字...答:=LEFT(MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-5),LENB(MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-5))-LEN(MID(CELL("file...