ANGELA

¥[¸É§UÄæ
iu1              iv1
¹ï·Ó       
A01*1        ®ü³ø®a*1
A02*2        ®ü³ø°ÓX2
A03*1        ®ü³ø»ÈX1
A02*2        ®ü³ø°ÓX2
C03*1        ¥¬ºX»ÈX1
C01*1        ¥¬ºX®aX1
a1=A01*1¡BA02*2¡BA03*1
b1=VLOOKUP(MID(A1,1,5),$IU$2:$IV$7,2,)&"¡B"&VLOOKUP(MID(A1,7,5),$IU$2:$IV$7,2,)&"¡B"&VLOOKUP(MID(A1,13,5),$IU$2:$IV$7,2,)

ANGELA

=VLOOKUP(MID(A1,1,3),$IU$2:$IV$7,2)&MID(A1,4,3)&VLOOKUP(MID(A1,7,3),$IU$2:$IV$7,2,)&MID(A1,10,3)&VLOOKUP(MID(A1,13,3),$IU$2:$IV$7,2,)&MID(A1,16,3)

ANGELA

[Ãö©óÀɮפW¤U¶Ç­ì«h]
1.°Q½×°Ï¥þ­±¶}©ñ·|­û¤W¶Çªþ¥ó
2.Àɮתþ¥ó½Ð¾¨¶q§R°£¤£¥²­n¸ê®Æ«áÀ£ÁY«á¤W¶Ç¡C
¤W¶ÇÀɮ׳̤j¦n³B¬O,ÁקK²{¦bªº±¡§Î,(¤Þ¥XµL­­ªº°ÝÃD),¦]§O¤HµLªk¤F¸Ñ§A¯u¥¿ªº·N¹Ï,¥u¯à½M¤lºN¶H.
¤@¯ë¶È·|°w¹ï°ÝÃD.©Ò¥H´£°Ý®É,­nºÉ¶qÅý¤H¤F¸Ñ§Aªº¥Øªº.
=VLOOKUP(MID(A1,1,3),$IU$2:$IV$7,2,)&IF(LEN(A1)-LEN(SUBSTITUTE(A1,"¡B",""))>=1,"¡B"&VLOOKUP(MID(A1,7,3),$IU$2:$IV$7,2,),"")&IF(LEN(A1)-LEN(SUBSTITUTE(A1,"¡B",""))>=2,"¡B"&VLOOKUP(MID(A1,13,3),$IU$2:$IV$7,2,),"")
¦³´X­Ó«~¶µ¨Ì¨Ò¦A¥[§Y¥i.

ANGELA

IF(LEN(A1)-LEN(SUBSTITUTE(A1,"¡B",""))
¤W­±³o¬q¨ç¼Æ¶Ç¦^¦³´X­Ó"¡B",
A1¬°¨Ò,A1¦r¦êªø«×´î¥hA1¦r¦ê¤¤ªº"¡B"§ï¦¨ªÅ¦r¦êªºªø«×,µ¥©ó3.

ANGELA

=VLOOKUP(MID(N3,1,3),¤Å°Ê!$A$1:$B$21,2,)&MID(N3,4,2)&IF(LEN(N3)-LEN(SUBSTITUTE(N3,"¡B",""))>=1,"¡B"&VLOOKUP(MID(N3,7,3),¤Å°Ê!$A$1:$B$21,2,)&MID(N3,10,2),"")&IF(LEN(N3)-LEN(SUBSTITUTE(N3,"¡B",""))>=2,"¡B"&VLOOKUP(MID(N3,13,3),¤Å°Ê!$A$1:$B$21,2,)&MID(N3,16,2),"")&...............