ÈçºÎÓÃExcelÌáÈ¡Éí·ÝºÅÂëÀïÃæµÄ³öÉúÈÕÆÚ£¿

ʱ¼ä£º2022.10.02 ·¢²¼ÈË£ºn96cbt6k

ÈçºÎÓÃExcelÌáÈ¡Éí·ÝºÅÂëÀïÃæµÄ³öÉúÈÕÆÚ£¿

Òѽâ¾öÎÊÌâ

¹È¸èn96cbt6kÓû§ÔÚ2022.10.02Ìá½»Á˹ØÓÚ¡°´óÖ÷Ô×ÈçºÎÓÃExcelÌáÈ¡Éí·ÝºÅÂëÀïÃæµÄ³öÉúÈÕÆÚ£¿¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-11-09T05:44:32¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬Ï£ÍûÄãÄܸÐÊܵ½,ÎÒ×îÕæ³ÏµÄлÒâ £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºÅ¼È»éÐýˆñR  

Ò»¡¢·½·¨Õ¹Ê¾

C2µ¥Ôª¸ñÊäÈ빫ʽ£º=--TEXT(MID(B2,7,8),"0-00-00")£¬Ïòϸ´ÖÆÌî³ä¡£Ò»´ÎÐÔÌáÈ¡ËùÓÐÉí·ÝºÅÂë¶ÔÓ¦µÄ³öÀ´×ÔÉúÈÕÆÚ¡£

¶þ¡¢¹«Ê½½âÊÍ£º

£¨1£©ÏÈ¿´MIDº¯Êý£ºMID(B2,7,8)µÄÒâ˼¾ÍÊÇ´ÓB2µ¥Ôª¸ñµÄµÚ7λ¿ªÊ¼½ÅÑØ½ÏÐг¤Çó½ØÈ¡£¬½ØÈ¡µÄ×Ö·û³¤¶ÈÊÇ8룬µÃµ½µÄ¼ÆËã½á¹û¾ÍÊÇ"19761204"¡£

£¨2£©½ÓÏÂÀ´ÓÃTEXTº¯Êý£¬½«MIDº¯ÊýµÃµ½µÄ×Ö·û´®±ä³ÉÈÕÆÚµÄÄ£Ñù£¬TÁª¸£ÒòEXT(MID(B2,7,8),"0-00-00ÊÂ")½«Îı¾×Ö·û´®"19761204"´ÓÓÒ²àµÄµÚ¶þλºÍµÚËÄλ֮¼ä¸÷¼ÓÉÏÒ»¸ö¶ÌºáϬ½á¹û±ä³É331215ÎÊ´ð"1976-12-04"¡£

£¨3£©¾­¹ýtextº¯ÊýÇÇ×°´ò°ç£¬Îı¾×Ö·û´®"19761204±ãºú¹ýÈ«ÀÏ"¾ÍÓÐÁËÈÕÆÚµÄÑù×ÓÁË£¬µ«ÊÇÕâÑùµÄ½á¹û½ö½öÊǺ¬¹Ìë֪¶ÈÊ¼ÔøÑÚÈ˶úÄ¿£¬»**»ÊÇÕæÕýµÄÈÕÆÚ¸ñ½ÇÉýÍþÈñà¸ùÖ³ÏòÕßʳʽ¡£ExcelÖз²ÊǾ­¹ýTEXT¡¢MID¡¢LEFT¡¢RIGh**TµÈº¯Êý¼Æ×éÈÈËãºóµÃ³öµÄÊýÖµÊÇÎı¾¸ñʽ£¬Ò»°ãÁ¬Ãü³åËÕ¸ïÔ²Ó¢Çé¿öÏ£¬²»ÄܲÎÓëºóÐøµÄ¼ÆËã´¦Àí¡£