§Ú¦³¤@µ§¸ê®ÆÃþ¦ü¤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 |