¦³¤°»ò¤½¦¡¥i¥H¨ú±oÀɮצWºÙ

vvcvc

¤ñ¦p:¦bAAA.xlsx½s¿è
§Ú·Q¨ú±oÀɮצWºÙAAA©Î¬OAAA.xlsx
¦³¤°»ò¨ç¼Æ¦³³o­Ó¥\¯à¶Ü?

zz5151353

ML089¤è¤½¦¡«Üºë²
¦ý§Ú¤£»Ý­n°ÆÀɦW.xlsxªº³¡¥÷
¥u¦n¼gªø¤@ÂI
vvcvc µoªí©ó 2017-3-24 09:54

=LEFT(MID(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),FIND("[",CELL("filename"))+1,99),FIND(".",MID(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),FIND("[",CELL("filename"))+1,99))-1)

vvcvc

ML089¤è¤½¦¡«Üºë²
¦ý§Ú¤£»Ý­n°ÆÀɦW.xlsxªº³¡¥÷
¥u¦n¼gªø¤@ÂI

ML089

¦^´_ 4# vvcvc

=MID(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),FIND("[",CELL("filename"))+1,99)

vvcvc

¤µ¤Ñ·Q¦n¦n¤F¸ÑCELL¨ç¦¡¡A¬d¬Ý¤pÀ°¤â»¡©úµo²{³o­Ó¼gªk¤]¥i¥H¨ú±oÀɦW
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH(".xlsx",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

vvcvc

¦]¬°¬Ý°_¨Ó«Ü½ÆÂø¡AÁÙ¨S¬ã¨s´Nª½±µ®M¥Î
¬Q¤Ñ¦³ªÅ­n¬ã¨s·s¶}BOOK1.xlsx¬ã¨s®Éµo²{cell¨ç¦¡§ì¨ìªº¬OªÅ¥Õ
´ú¸ÕBOOK1~BOOK10³£¦p¦¹

¤µ¤Ñ¸õ¹L³o­Ó°ÝÃD§â¤½¦¡¾ã­Ó¬ÝÀ´«áµo²{ª©¥D¦Ò¼{¶W©P¸Ô
¤½¦¡¬Ý°_¨Ó¥i¥H³q¥Î©Ò¥H±¡ªp
cell§ì¤£¨ìÀɦWªº°ÝÃD¤]§ä¨ì­ì¦](¦]¬°¨S¦sÀÉ¡A·íµM§ì¤£¨ì§t§¹¾ã¸ô®|ªºÀɦW)

­ã´£³¡ªL

=TRIM(RIGHT(SUBSTITUTE(LEFT(CELL("filename",A1),FIND(".xlsx]",CELL("filename",A1))-1),"[",REPT(" ",99)),99))