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

[µo°Ý] ½Ð±Ð¨ú±o·í«eÀɮשҦbªº¸ê®Æ§¨¦WºÙ,¤£§t¸ô®|?

[µo°Ý] ½Ð±Ð¨ú±o·í«eÀɮשҦbªº¸ê®Æ§¨¦WºÙ,¤£§t¸ô®|?

A1 =MID(CELL("filename"),1,FIND("[",CELL("filename"))-2)

¥Ø«e¬O¥u¨ú±o¦p A1 =  D:\¥Ø¿ý\´ú¸Õ¸ê®Æ§¨  

§Æ±æ±o¨ì  A1 = ´ú¸Õ¸ê®Æ§¨

½Ð¦U¦ì¤j¤j«ü¾É¤F

=TRIM(LEFT(RIGHT(SUBSTITUTE(CELL("filename"),"\",REPT(" ",99)),198),99))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

·PÁÂ~À°¤F¤j¦£...³o¤½¦¡¯u¬O¦³¬Ý¨S¦³À´

TOP

¦^´_ 3# starry1314

=TRIM(LEFT(RIGHT(SUBSTITUTE(CELL("filename"),"\",REPT(" ",99)),198),99))

SUBSTITUTE(CELL("filename"),"\",REPT(" ",99)) ´N±N "\"¥Î99­ÓªÅ®æ¨ú¥N

¨Ò¦p
CELL("filename") = D:\A\B\C\filename
SUBSTITUTE(CELL("filename"),"\",REPT(" ",9)) ="D:         A         B         C         filename"
·íªÅ®æ¥Î99®æ®É¡A´N¥i¥H±N ºÏºÐ¡B¥Ø¿ý...¡BÀɮצWºÙ¥ÎªÅ®æ¤À¹jªº§ó¶}¡C

«á­±´N¥i¥H¥Î MID RIGHT LEFT µ¥¨ç¼Æ¨ú¥X§A­nªº³¡¤À
³Ì«á¥Î TRIM ±N«e«áªÅ®æ²M°£
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-9-9 15:27 ½s¿è

¦^´_ 4# ML089


    ·PÁ«ü¾É....¸Ñ»¡§¹ ¯u¬O²³æ©úÁA....

RIGHT 198 ¬O¨ú¥X  ³Ì¥kÃä ¥Ø¿ý¦WºÙ\ÀɮצWºÙ
¦A¥Îleft ¨ú¥X¥ªÃä²Ä¤@­Ó¦ì¸m
trim «á§R°£ °£©Ò­n¸ê®Æ¥H¥~ªº¸ê®Æ
¤£ª¾²z¸Ñ¬O§_¦³»~

=TRIM(LEFT(RIGHT(SUBSTITUTE(CELL("filename"),"\",REPT(" ",99)),198),99))

TOP

¦^´_ 5# starry1314


¨S¦³¿ù!
¥Ø¿ý¦WºÙ¥Ñ¥k¦Ü¥ª²Ä¤G­Ó¡A©Ò¥H¥ÎRIGHT+LEFT¨Ó¨ú¡C
­Y¬O¥Ñ¥ª¦Ü¥k´N¥ÎMID¨Ó¨ú
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD