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

[µo°Ý] ¥u¨ú³Ì«e­±¤@¬qªº­^¤å,½Ð°Ý¸Ó¤½¦¡¥i§_¦A²¤Æ©O?

[µo°Ý] ¥u¨ú³Ì«e­±¤@¬qªº­^¤å,½Ð°Ý¸Ó¤½¦¡¥i§_¦A²¤Æ©O?

¥»©«³Ì«á¥Ñ starry1314 ©ó 2016-10-12 13:13 ½s¿è

Àx¦s®æA6 :10AD502E    or 10A502E
¤½¦¡:=IF(IFERROR(AND(VALUE(RIGHT(MID(A6,2+COUNT(-LEFT(A6,2)),2),1))>=0,VALUE(RIGHT(MID(A6,2+COUNT(-LEFT(A6,2)),2),1))<10),"false"),MID(A6,2+COUNT(-LEFT(A6,2)),1),MID(A6,2+COUNT(-LEFT(A6,2)),2))

¤W¤è¤½¦¡¥i¦]¤W­±¨âºØ®æ¦¡°µ´À´«¨ú¥X³Ì«e­±¤@¬q­^¤å¦r¥À....
MID(A6,2+COUNT(-LEFT(A6,2)),1)  ¥u¨ú²Ä¤@­Ó­^¤å¦r¥À

½Ð°Ý¦p¦ó§ó§ï¥iÅý¨âºØª¬ªp³£¾A¥Î©O? ³Ì¤W¤è¤½¦¡¦³ÂI¤¾ªø,¦]Àɮפº»Ý¨Ï¥Î±Nªñ3000¦¸

http://blog.xuite.net/hcm19522/twblog/456388045

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-10-12 17:29 ½s¿è

=MID(A6,3,MATCH(,0/MID(A6,{4,5,6,7,8,9},1),))

¤½¦¡³Ì¦h¥i¥H§P§O6­Ó­^¤å¦r¡A½Ð¦Û¦æ¥[´î
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089


   ·PÁ¤j¤jªº¦^ÂÐ,²¼äªº¤½¦¡

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2016-10-30 14:32 ½s¿è

¦^´_ 3# ML089


   M¤j¹J¨ì­Ó§xÂZ=MID(A6,3,MATCH(,0/MID(A6,{4,5,6,7,8,9},1),))
¦pªG¦A½s¸¹«á­±¬O±µ0ªºµe·|±N0¤]Åã¥Ü¥X¨Ó
¦p 10AA08A ¥u­n¨ú¥X AA  ¦ý·|Åܦ¨AA0
«ç»ò§ï³£µLªk§¹¬ü....

TOP

¦^´_ 5# starry1314


   
=MID(A6,3,MATCH(,0*MID(A6,{4,5,6,7,8,9},1),))

TOP

¦^´_ 6# ­ã´£³¡ªL


    ¤Ó·PÁ¤F¡D¡D¡D¡D¡D¡D¡D¡D¡D
·Q½Ð°Ý¡@¡¯¡@¡þªº®t²§¬O¡H¡@¡@°£¡@­¼¡H

TOP

¦^´_ 7# starry1314


0/0 ¤À¥À¬°0, ¿ù»~­È

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD