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...