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

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

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

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

TOP

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