excel 表格中提取字母 就是像 abc123def 我要acbdef abcde543212fg 我...答:假设数据在A列:B1单元格公式:=LOOKUP(,-LEFT(RIGHT(A1,LEN(A1)-MATCH(,0/(MID(A1,{1,2,3,4,5,6,7},1)<="9"),)+1),ROW(INDIRECT("$1:"&LEN(RIGHT(A1,LEN(A1)-MATCH(,0/(MID(A1,{1,2,3,4,5,6,7},1)<="9"),)+1)))*-1 C1单元格公式:=SUBSTITUTE(SUBSTITUTE...
Excel求只提取大写字母A到Z的公式答:求只提取/左边大写字母A到Z,且A1单元格内没有/则提取全部A到Z大写字母的公式 B1单元格输入=IF(C1=0,"",IF(ISNUMBER(FIND("/",A1)),IF(C1<=LEN(A1),IF(ISNUMBER(MATCH(CODE(MID(LEFT(A1,FIND("/",A1)),C1,1)),ROW($A$65:$A$90),0)),B1&MID(LEFT(A1,FIND("/",A1)),C1...