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

[µo°Ý] ¨â­Ó°ÝÃD½Ð±Ð¡G±qA1´£¨ú¼Æ¦r¨ìB1¡A¥H¤Î½Æ»s¥X­pºâµ²ªG..

[µo°Ý] ¨â­Ó°ÝÃD½Ð±Ð¡G±qA1´£¨ú¼Æ¦r¨ìB1¡A¥H¤Î½Æ»s¥X­pºâµ²ªG..

¤£¦n·N«ä¡A¦³´X­Ó·M²Âªº°ÝÃD·Q½Ð±Ð¤j®v¡ã
³o¨Ç¤p°ÝÃD§xÂZ¤F§Ú³\¤[¡A¥Ñ©ó¥Ø«e¦³¤jµ§ªº¸ê®Æ§Ç¦C»Ý­n§Ú§â¥LÂà´«¦¨¤@¯ë¤H¥i¥H¬ÝªºÀ´ªº®æ¦¡±Æ¦C
¤£±o¤£¥Ñ§Ú³o­ÓEXCELªºªù¥~º~¥h°õ¦æ...

°ÝÃD¬O³o¼Ëªº¡ã

Ãþ¦ü¹³³o¼Ëªºtxt¥´¥d°T®§¡A§Ú»Ý­n§â¥L¶K¦bexcel«á¡A¦Û°Ê±Æ¦C®æ¦¡
2013031408570003101
2013031408570029401
2013031409040033901
2013031409160033201

2013031408570003101 ¡Ö 2013¦~03¤ë14¸¹ 08:57 ½s¸¹00031 ¥d§Ç01

§Úªººc·Q¬O §â¼Æ¦r¤À¶} 2013¤@®æ 0314¤@®æ 0857¤@®æ 00031¤@®æ 01¤@®æ



°ÝÃD1¡G¦pªG­n´£¨úA1¤@¦ê¼Æ¦r¤¤ªº¬Y¦ì¼Æ¨ìB1¡A­n«ç»ò´£¨ú¡H
¨Ò¦p¡G2013031409160033201 §Ú­n´£¨ú¤¤¶¡ªº 0314 ¨ìB1¡A 0916¨ìC1

°ÝÃD¢±¡G·íÂà´«©Î¬O­pºâ¥X¨Óªº¼Æ¦r¡A¦b®æ¦C¤W§Ú»Ý­n§â¥L½Æ»s¦¨TXTÀÉ¡A
«o¥u¯à½Æ»s¥X"¤½¦¡"¡A¦¹ºØ±¡ªp§Ú¥²¶·­n°µ¨Ç¤°»ò¡A¤~¯à½Æ»s¥XEXCEL­pºâ¥X¨Óªºµ²ªG¡H

¦^´_ 1# chean64

³oºØ§â¤å¦r¸ê®Æ¤À³Î¥X©T©w¼e«×ªº¦hÄæ¸ê®Æ
¥i¨Ï¥Î¸ê®Æ­åªR¥\¯à´N¥i»´ÃP¹F¦¨
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

§Ú¦¨¥\¤F¡A
¥i¬O³o¼Ë¤@¨Ó¥²¶·¦³·sªº¸ê®Æªñ¨Ó´N¥u¯à¦b¸ê®Æ­åªR¤@¦¸¡A¦b¤@¦¸ªº­«½Æ¼W¥[¤å¦r¤º®e
¯uªºµLªk¨Ï¥Î¹Bºâªº¤è¦¡³B²z¶Ü¡H
¤u±ýµ½¨ä¨Æ¡A¥²¥ý§Q¨ä¾¹

TOP

¦^´_ 3# chean64
½Ð°Ñ¦Ò
°ÝÃD: 2013031409160033201 §Ú­n´£¨ú¤¤¶¡ªº 0314 ¨ìB1¡A 0916¨ìC1
µª: B1Àx¦s®æ¤½¦¡=MID(A1,5,4)     C1Àx¦s®æ¤½¦¡=MID(A1,9,4)

TOP

¦^´_ 4# p212


    ¦¨¥\¤F¡I
¤S¾Ç¤F¨â­Ó«ü¥O¡I

ÁÂÁ¡I ÁÂÁ¡㠤ӷPÁ¤F ~~~
¤u±ýµ½¨ä¨Æ¡A¥²¥ý§Q¨ä¾¹

TOP

¦pªG¸g±`°µ¡A¥i¥H¦Ò¼{¥Î¥¨¶°¡C

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD