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

[µo°Ý] ¦r¦êªº¤À³Î

[µo°Ý] ¦r¦êªº¤À³Î

§Ú¦³¤@µ§¸ê®ÆÃþ¦ü¤U­±ªº¸ê®Æ
D10026J
X12037L
CF15020R
W10J20036K
WH13526R5
JR15037KA
S21Q20024KD

³o¨Ç¸ê®Æªº³W«h´N¬O¡]¥N½X1¡^11122¡]¥N½X2¡^
¨â²Õ¥N½X¤¤¶¡§¨µÛ¤­­Ó¼Æ¦r
§Ú»Ý­n§â³o¨Ç¸ê®Æ¤À¦¨¡u¥N½X1¡A111¡A22¡A¥N½X2¡v³o¥|­ÓÀx¦s®æ
§Úªº¨ç¼Æ¼gªk¦p¤U
¥N½X1¡G{=LEFT(§Úªº¸ê®Æ,MATCH(TRUE,ISNUMBER(1*MID(§Úªº¸ê®Æ,ROW($1:$10),1)),0)-1)}
111¡G{=MID(§Úªº¸ê®Æ,MATCH(TRUE,ISNUMBER(1*MID(§Úªº¸ê®Æ,ROW($1:$10),1)),0),3)}
22¡G{=MID(§Úªº¸ê®Æ,MATCH(TRUE,ISNUMBER(1*MID(§Úªº¸ê®Æ,ROW($1:$10),1)),0)+3,2)}
¥N½X2¡G{=MID(§Úªº¸ê®Æ,MATCH(TRUE,ISNUMBER(1*MID(§Úªº¸ê®Æ,ROW($1:$10),1)),0)+5,4)}
³o­Ó¼gªk¥i¥H¾A¥Î©ó¤j³¡¥÷ªº¸ê®Æ
¦ý¹J¨ì¦pS21Q20024KDªº¸ê®Æ®É¥N½X1¥u·|Ū¨ìS¡A¥N½X2¥u·|Ū¨ì024K
¸ò§Ú©Ò­nªº¸ê®Æ¤£²Å¦X¡A¥N½X1=S21Q¡A¥N½X2=KD
°w¹ï³o´Xµ§¸û¯S®íªº¸ê®Æ¡A¨ç¼Æ³¡¥÷­n«ç¼Ë­×§ï¤ñ¸û¦n¡H

©w¸q¦WºÙAA
AA=MATCH(1=1,ISNUMBER(--MID(Sheet1!$A1,ROW(Sheet1!$1:$9),5)),)
B1=LEFT(A1,AA-1)
C1=MID(A1,AA,3)
D1=MID(A1,AA+3,2)
E1=MID(A1,AA+5,9)
¤wª¾¤¤¶¡¦³³sÄò5­Ó¼Æ¦r,§ä¥X¥¦¶}©lªº¦ì¸m,§Y¬OAA.

TOP

¥»©«³Ì«á¥Ñ callinner ©ó 2011-11-7 17:27 ½s¿è

¦^´_ 2# ANGELA

¸Ñ¨M¤F
³o­Ó¼gªk¤ñ§Ú­ì¥»ªºÂ²³æ¦h¤F
¤S¤W¤F¤@½Ò¡A·PÁÂ^^

¥i¥H¦A¶¶«K½Ð°Ý¤@¤U
--MID(¤u§@ªí1!$A1,ROW($1:$10),5)
¤¤ªº--¬O¤°»ò·N«ä¡H
·PÁÂ^^

TOP

¦^´_ 3# callinner


   
   
http://forum.twbts.com/thread-4980-1-2.html
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD