在excel中按字符截取字符串函数

=right(filename,len(filename)-find("]",filename))
=RIGHT(A4837,LEN(A4837)-FIND(":",A4837)) 截取查找冒号后边的字符串
 » 本站地址:http://www.gomoth.com

标签: