[已处理] 怎样从单元格中提取字母与数字混合内容中的字母总价

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(待处理的字符串,0,""),1,""),2,""),3,""),4," "),5,""),6,""),7,""),8,""),9,"")

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4," "),5,""),6,""),7,""),8,""),9,"")

duxp 发表于 2022-10-8 22:14
一个正则表达式搞定，提取字符串字母
[a-zA-Z]+

Lay.Li 发表于 2022-10-8 18:02
您好，这里使用上方的excel函数就可以了哈，您也可以在网上查找其他的excel函数使用哈

duxp 发表于 2022-10-9 08:48
服务端命令安装一下插件，豪哥合集，里面有个取正则文本

duxp 发表于 2022-10-9 08:55
https://marketplace.grapecity.com.cn/ApplicationDetails?productID=SP2202280001&productDetailID=D22 ...

duxp 发表于 2022-10-9 09:08
JS的话，你用下面的即可解决
var str = "NHJCHT220304005";
str = str.match(/[a-zA-Z]+/);

duxp 发表于 2022-10-9 09:34
这是提取字母的，只要是字母都可以，不管在什么地方，不管是什么组合