ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

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

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

TOP

¦]¬°¬Ý°_¨Ó«Ü½ÆÂø¡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)

TOP

¤µ¤Ñ·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)

TOP

¦^´_ 4# vvcvc

=MID(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),FIND("[",CELL("filename"))+1,99)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ vvcvc ©ó 2017-3-24 10:03 ½s¿è

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

TOP

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)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD