- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
[Ãö©óÀɮפ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. |
|