ªð¦^¦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¿è

¹Ï¤ù.jpg
2020-1-15 12:17
¤pªZ

=SUBSTITUTE(MID(A1,5,99),RIGHT(MID(A1,5,99),5),"-B")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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 : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD