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

½Ð°ÝAÄ椺¦p¦ó³]©w±Æ§Ç

½Ð°ÝAÄ椺¦p¦ó³]©w±Æ§Ç

½Ð°ÝAÄ椺¦p¦ó³]©w±Æ§Ç¡G
·Ó±Æ§Ç«ö¶s³]©w¡A¦ý¬O¦bA158Àx¦s®æ¥H¤U¡A³£±Æ§Ç¿ù»~¡A½Ð°Ý¤½¦¡­n¦p¦ó³]©w

¦p¦ó±Æ§Ç.zip (7.32 KB)

joyce

¢Ð¢±¡G
=REPLACE(A2,14,0,IF(COUNT(-MID(A2&-11,FIND("-",A2&"-"),3)),,0))

©Î¡G
=MID(A2,4,9)&TEXT(LOOKUP(1,--MID(A2&0,FIND("-",A2&"-"),{2,3})),";-00;")

¥Î¢ÐÄæ±Æ§Ç

TOP

¦^´_ 2# ­ã´£³¡ªL


    ÁÂÁ¤j®v
joyce

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD