|
A |
B |
C |
| test\11\taog | taog | |
| taog\ta\now | now | |
| tt\hh\blue | blue |
C的值是这样得到的
=RIGHT(A2,LEN(A2)-FIND(",",SUBSTITUTE(A2,"\",",",LEN(A2)-LEN(SUBSTITUTE(A2,"\","")))))
数字和汉字分开
=LOOKUP(9E+307,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&1234567890)),ROW($1:$1024)))
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22392018/viewspace-754700/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
