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

[µo°Ý] Â^¨ú¬Y¦r¦ê

[µo°Ý] Â^¨ú¬Y¦r¦ê


·QÂ^¨úAÄæÀx¦s®æ¦r¦êªº­Ë¼Æ²Ä5­Ó©Î­Ë¼Æ²Ä5­Ó©M²Ä6­Óªº¦r¦ê¡A
½Ð°Ý¡JB1ªº2003ª©¨ç¼Æ¤½¦¡¡H
ÁÂÁ¡I

´ú¸ÕÀÉ®× : Â^¨ú¬Y¦r¦ê.rar (1.91 KB)

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-10-31 01:59 ½s¿è

·Q¤F³\¤[¡A¤~¼g¥X¥¿½Tµª®×ªº¤½¦¡^^"
B1=MID(LEFT(A1,LEN(A1)-4),14,2)
½Ð°Ý : ÁÙ¦³§Oªº¼gªk¶Ü?
ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-10-31 02:59 ½s¿è

2¼Ó¤½¦¡ªº§xÂZ¬O
=MID(LEFT(A1,LEN(A1)-4),14,2)ªº14¬O¥H¤H¤u­p¸U¥X¨Óªº¡A
¦pªG14¥HLEN(LEFT(A1,LEN(A1)-4))®M¤J¡A
LEN(LEFT(A2,LEN(A2)-4))·|Åܦ¨15¡A¤£¬O14¡A
½Ð°Ý : ¦³¦ó¨ç¼Æ¯à©T©w­pºâ¥X14©Î¤£¥Î­pºâ¦ì¼Æ§Y¥i¦P®ÉÂ^¨ú1­Ó¤Î2­Ó¼Ðªº¦r¤¸ªº¨ç¼Æ¶Ü?
ÁÂÁÂ!

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-10-31 12:42 ½s¿è

¦^´_ 4# hcm19522
³£¤£¶·­n¥H¤H¤u¥h­pºâªº¸ÑÃD¤½¦¡¡A¤~¬O¥¿½Tªº¸Ñµª¡C
ÁÂÁ¤j¤jªº¸Ñ´b¡C
±zªº¸ÑÃD¤½¦¡«D±`´Î¡C·P®¦^^

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD