Excel实用命令
Excel提取最后一个""前面的数据
=IFERROR(RIGHT(E1,LEN(E1)-FIND("",SUBSTITUTE(E1,"","",LEN(E1)-LEN(SUBSTITUTE(E1,"",""))))),"")
=IFERROR(RIGHT(E1,LEN(E1)-FIND("",SUBSTITUTE(E1,"","",LEN(E1)-LEN(SUBSTITUTE(E1,"",""))))),"")
LEN(E1)-LEN(SUBSTITUTE(E1,"",""))
...
原创
2021-04-09 21:34:49 ·
175 阅读 ·
0 评论