从单元格里无规律的数字和字母串中只提取字母。例如 abc123def 我要acbdef abcde543212fg 我要提取 abcdefg
用公式,真的很强大呀
如果无规律字母数字串放在A1单元格中,那么在任一空白单元格如B1中输入公式
=IF(TYPE(MID(A1,1,1)*1)=1,"",MID(A1,1,1))&IF(TYPE(MID(A1,2,1)*1)=1,"",MID(A1,2,1))&IF(TYPE(MID(A1,3,1)*1)=1,"",MID(A1,3,1))&IF(TYPE(MID(A1,4,1)*1)=1,"",MID(A1,4,1))&IF(TYPE(MID(A1,5,1)*1)=1,"",MID(A1,5,1))&IF(TYPE(MID(A1,6,1)*1)=1,"",MID(A1,6,1))&IF(TYPE(MID(A1,7,1)*1)=1,"",MID(A1,7,1))&IF(TYPE(MID(A1,8,1)*1)=1,"",MID(A1,8,1))&IF(TYPE(MID(A1,9,1)*1)=1,"",MID(A1,9,1))&IF(TYPE(MID(A1,10,1)*1)=1,"",MID(A1,10,1))&IF(TYPE(MID(A1,11,1)*1)=1,"",MID(A1,11,1))&IF(TYPE(MID(A1,12,1)*1)=1,"",MID(A1,12,1))&IF(TYPE(MID(A1,13,1)*1)=1,"",MID(A1,13,1))&IF(TYPE(MID(A1,14,1)*1)=1,"",MID(A1,14,1))&IF(TYPE(MID(A1,15,1)*1)=1,"",MID(A1,15,1))
说明:该公式最多只能满足不超过15个字符组成的字符串!如果字符串中的字符数超过15,可仿照公式中的结构对公式加长。
。