...提取某一单元格的中间两位数字,并以改提取数字另外加文字的形式显...答:=IF(OR(--MID(A2,3,1)=0,--MID(A2,5,1)=0),LEFT(A2,2)&"级"&MID(A2,4,1)&"班"&RIGHT(A2,1)&"号",LEFT(A2,2)&"级"&MID(A2,3,2)&"班"&RIGHT(A2,2)&"号")
如何提取出表格第一列中的数字出来,到第二列?答: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)