EXCEL中如何用函数去数字,保留文本? 比如 ABC123 结果为ABC 比如 A1...答:=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,"")这个公式可以去掉0-7这几个数字 因为一个单元格只能叠加8个函数,所以 你如果想去掉8-9,自己在另一个单元格d1继续后面加输入,=...
excel单元格中如何用函数删除文字保留数字答:b1=IF(COUNT(FIND({1,2,3,4,5,6,7,8,9,0},A1)),-LOOKUP(1,-LEFT(MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&1234567890)),100),ROW($1:$20))),"")下拉
excel单元格中如何用函数删除文字保留数字答:=MID(A1,MATCH(0,0*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),),MATCH(0,0*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))-MATCH(0,0*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),)+1)