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

[µo°Ý] ¦p¦ó¥Î¨ç¼Æ§R°£«e­±4­Ó¦r¤¸¦P®É§ïÅÜ«á­±5­Ó¦r¤¸Åܦ¨-B

[µo°Ý] ¦p¦ó¥Î¨ç¼Æ§R°£«e­±4­Ó¦r¤¸¦P®É§ïÅÜ«á­±5­Ó¦r¤¸Åܦ¨-B

¥»©«³Ì«á¥Ñ show5217 ©ó 2020-1-15 12:17 ½s¿è

¤pªZ

=SUBSTITUTE(MID(A1,5,99),RIGHT(MID(A1,5,99),5),"-B")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2020-1-17 09:48 ½s¿è

=MID(LEFT(A1,18),5,19)&"-B"
=MID(A1,5,14)&"-B"

TOP

¦^´_ 2# hcm19522


    ÁÂÁÂ
¤pªZ

TOP

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


    ÁÂÁÂ
¤pªZ

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD