¦³¤°»ò¤½¦¡¥i¥H¨ú±oÀɮצWºÙ
- ©«¤l
- 144
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-26
- ³Ì«áµn¿ý
- 2023-6-23
|
¦³¤°»ò¤½¦¡¥i¥H¨ú±oÀɮצWºÙ
¤ñ¦p:¦bAAA.xlsx½s¿è
§Ú·Q¨ú±oÀɮצWºÙAAA©Î¬OAAA.xlsx
¦³¤°»ò¨ç¼Æ¦³³oÓ¥\¯à¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-19
|
=TRIM(RIGHT(SUBSTITUTE(LEFT(CELL("filename",A1),FIND(".xlsx]",CELL("filename",A1))-1),"[",REPT(" ",99)),99)) |
|
|
|
|
|
|
- ©«¤l
- 144
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-26
- ³Ì«áµn¿ý
- 2023-6-23
|
¦]¬°¬Ý°_¨Ó«Ü½ÆÂø¡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
- 144
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-26
- ³Ì«áµn¿ý
- 2023-6-23
|
¤µ¤Ñ·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) |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 4# vvcvc
=MID(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),FIND("[",CELL("filename"))+1,99) |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 144
- ¥DÃD
- 33
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-26
- ³Ì«áµn¿ý
- 2023-6-23
|
¥»©«³Ì«á¥Ñ vvcvc ©ó 2017-3-24 10:03 ½s¿è
ML089¤è¤½¦¡«Üºë²
¦ý§Ú¤£»Ýn°ÆÀɦW.xlsxªº³¡¥÷
¥u¦n¼gªø¤@ÂI |
|
|
|
|
|
|
- ©«¤l
- 206
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE 365
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¥x¥_
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2023-6-18
|
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
|
|
|
|
|