Óû§Ãû£ºjsjhlld
ʹÓú¯Êý¹«Ê½ÌáÈ¡£¬ÔÚ¶ÎδµÀ¹ÛÆß¸ÐÁ¬¿àµ¥Ôª¸ñÄÚÊäÈëÒÔϹ«Ê½£¬²¢À´×ÔÏòÏÂÌî³ä¼´¿É¡£
=TÉÙÕûÏØ²»EXT(MID(B2,7,8),"0-00-00")+0
½âÊÍ£º
Õâ¸ö¹«Ê½ÊÇÓС°MIDº¯Êý¡±¡°TEXTº¯Êý¡±×é³É£¬ÎÒÍò´¹ÃÇÏÖÔÚÉí·ÝºÅÂëB2µ¥Ôª¿ì½½×Ó³ÁÁµÃζ¸ñÖдÓËüµÄµÚ7λ¿ªÊ¼½ØÈ¡£¬½ØÈ¡µÄ×Ö·û³¤¶ÈÊÇ8룬µÃµ½µÄ¼ÆËã½á¹û¾ÍÊÇ¡°1331215ÎÊ´ð9831008¡±¡£È»ºóÔÚͨ¹ýTEXTº¯Êý¡°TEXT(¸±»òɳŮԺÑÇMID(B2,7,8),"0-00-00")¡±ÈÃËü±ä³É¡°1983-10-08¡±ÕâÑùµÄ¸ñʽ¡£
¾¹ýÕâÑùµÄ¹«Ê½ºó£¬¾ÍÓÐÁËÈÕÆÚµÄ¸ñʽ¡°1983-10-08¡±£¬µ«ÊÇÕâÑùµÄ½á¹ûÉ̾Öÿά˾ÀàÏìºÜ»**»ÊÇÕæÕýµÄÈÕÆÚ¸ñʽ¡£¾¹ý¡°MIDº¯Êý¡±¡°TEXTº¯Êý³Éí½ðÅ£ÓÚ¡±µÈº¯Êý¼ÆËãºóµÃ³öµÄÊýÖ¼ÊÇ´º»ù¹Å¿Æ¸ÃÒԸᄚ·òÕÂÎı¾¸ñʽ£¬Ò»°ãÇé¿öÏ£¬²»ÄܲÎÓëºóÐøµÄ¼ÆËã´¦Àí¡£
ͨ³£°ÑÕâÖÖÐÎʽ½Ð×ö¼ÓÁãÔËË㣬ͨ¹ýÔËË㣬½«Îı¾¸ñʽµÄÊýÖµ±ä³ÉÕæÕýµÄÈÕÆÚ¸ñʽ£¬Èç¹û½«¼ÓÁã»»³É1*£¨1³ËÒÔÉÌÃæ¹¹Ãûµã×åÍûÓÃÖÖ£©£¬Ò²¿ÉÒÔʵÏÖ½«ÎÄ·¢±¾¸ñʽÏòÊýÖµ¸ñʽµÄת»»µÄ¡£