通过excel 获取完整路径中的文件名

=RIGHT(A2,LEN(TRIM(RIGHT(SUBSTITUTE(A2,"\",REPT(" ",LEN(A2))),LEN(A2)))))

posted on 2020-12-08 14:45  破晓520  阅读(449)  评论(0)  编辑  收藏  举报

Powered by: 博客园 Copyright © 2024 破晓520
Powered by .NET 8.0 on Kubernetes