本帖最后由 xpyjj612 于 2015-9-18 16:39 编辑
=IF(C4="","",IF(OR(ISERROR(FIND(".",C4)),IFERROR(FIND(".",C4,LEN(C4)),0)),"文件夹",IF(IFERROR(FIND(".",C4,LEN(C4)-1),0),MID(C4,FIND(".",C4,LEN(C4)-1)+1,4),IF(IFERROR(FIND(".",C4,LEN(C4)-2),0),MID(C4,FIND(".",C4,LEN(C4)-2)+1,4),IF(IFERROR(FIND(".",C4,LEN(C4)-3),0),MID(C4,FIND(".",C4,LEN(C4)-3)+1,4),"文件夹")))))
本帖最后由 蓝粆 于 2015-9-18 17:37 编辑
{:22:} 水水 - =IF(ISERR(FIND(".",LEFT(C4,LEN(C4)-1))),"文件夹",TRIM(RIGHT(SUBSTITUTE(C4,".",REPT(" ",99)),99)))
复制代码
|