»¶Ó­À´µ½ÅàѵÎÞÓÇÍø£¡

È«¹úÇл»

×ÉѯÈÈÏß 400-001-5729

λÖãºÅàѵÎÞÓÇÍø > ÐÂÎÅ×ÊѶ > µçÄÔ/IT > ¼ÆËã»úµÈ¼¶ >  ¼ÆËã»ú¶þ¼¶¿¼ÊÔÖÐexcelº¯ÊýµÄ֪ʶµãÓÐÄÄЩ£¿

¼ÆËã»ú¶þ¼¶¿¼ÊÔÖÐexcelº¯ÊýµÄ֪ʶµãÓÐÄÄЩ£¿

À´Ô´£ºwww.pxwy.cn ·¢²¼ÈË£ºÔƶä

2021-12-24 10:17:28|ÒÑä¯ÀÀ£º324´Î

¼ÆËã»ú¶þ¼¶¿¼ÊÔÖÐexcelº¯ÊýµÄ֪ʶµãÓÐÄÄЩ£¿

ÏÂÃæ½éÉÜÒ»ÏÂexcelº¯ÊýµÄ֪ʶ¡£

Ò»¡¢Left/Right:×ÛºÏÓ¦ÓÃ
    •·µ»ØÉí·ÝÖ¤ºÅÖеġ°³öÉúÄê·Ý¡±ÐÅÏ¢
    •ÀýÈ磺A1µ¥Ôª¸ñÓÐÉí·ÝÖ¤ºÅ Âë¡°352624198208226319¡±
    •ʹÓÃRight(Left(A1,10),4) µÃµ½½á¹û1982
¶þ¡¢Mid: ½ØÈ¡º¯×Ö·û´®Êý
    •ÓÃ;: Mid·µ»ØÎı¾´®ÖдÓÖ¸¶¨Î»ÖÿªÊ¼µÄÌØ¶¨ÊýÄ¿µÄ×Ö·û£¬¸ÃÊý Ä¿¿ÉÒÔÓÉÓû§Ö¸¶¨¡£
    •Óï·¨£ºMid(Îı¾´®£¬¿ªÊ¼Î»Ö㬷µ»Ø×Ö·ûµÄ¸öÊý)
    •²ÎÊý£º¿ªÊ¼Î»ÖÃÊÇÎı¾ÖÐÒªÌáÈ¡µÄµÚÒ»¸ö×Ö·ûµÄλÖã¬Îı¾ÖеÚÒ» ¸ö×Ö·ûµÄ¿ªÊ¼Î»ÖÃΪ1£¬ÒÔ´ËÀàÍÆ¡£
Èý¡¢LEN: ¼ÆËã×Ö·û´®³¤¶È
    •ÓÃ;: LEN·µ»ØÎı¾µÄ×Ö·ûÊý
    •Óï·¨£ºLEN(Îı¾)
    •²ÎÊý£º´Ëº¯ÊýÓÃÓÚË«×Ö½Ú×Ö·û£¬ÇÒ¿Õ¸ñÒ²½«×÷Ϊ×Ö·û½øÐÐͳ¼Æ¡£
ËÄ¡¢TRIM: ɾ³ýÖ¸¶¨×Ö·û´®¶àÓàµÄǰµ¼ºÍºó׺µÄ¿Õ¸ñ
    •ÓÃ;: ɾ³ýǰµ¼ºÍºó׺µÄ¿Õ¸ñ
    •Óï·¨£ºTRIM(Îı¾)
    •²ÎÊý£º×Ö·û´®
Îå¡¢Replace: Ìæ»»Ö¸¶¨Î»Öô¦µÄÈÎÒâÎı¾
    •ÓÃ;: REPLACEʹÓÃÆäËûÎı¾´®²¢¸ù¾ÝËùÖ¸¶¨µÄ×Ö·ûÊýÌæ»»ÁíÒ»Îı¾´®ÖеIJ¿·ÖÎı¾¡£
   •Óï·¨£ºReplace(ÐèÒªÌæ»»Æä²¿·Ö×Ö·ûµÄÎı¾£¬±»Ìæ»»×Ö·ûµÄÆðʼλÖã¬Ìæ»»µÄ×Ö·û¸öÊý£¬ÓÃÓÚÌæ»»µ½Ô­Îı¾ÖÐÈ¥µÄ×Ö·û)
Áù¡¢SUBSTITUTE: Ìæ»»Ö¸¶¨Îı¾
    •ÓÃ;: ÔÚÎÄ×Ö´®ÖÐÓÃÐÂÎı¾Ìæ´ú¾ÉÎı¾¡£Èç¹ûÐèÒªÔÚÒ»¸öÎÄ×Ö´®ÖÐÌæ»»Ö¸¶¨Îı¾£¬¿ÉÒÔʹÓÃSUBSTITUTE£»Èç¹ûÐèÒªÔÚijһ×Ö·û´®ÖÐÌæ»»Ö¸¶¨Î»Öô¦µÄÈÎÒâÎı¾£¬¾ÍÓ¦¸ÃʹÓú¯ÊýREPLACE¡£
    •Óï·¨£º SUBSTITUTE(ÐèÒªÌæ»»Æä²¿·Ö×Ö·ûµÄÎı¾£¬Ðè±»Ìæ»»¾ÉÎı¾£¬ÓÃÓÚÌæ»»µÄÎı¾£¬[µÚ¼¸´Î³öÏֵľÉÎı¾])
    •²ÎÊý£ºÈç¹û²»ÊäÈëµÚËĸö²ÎÊý½«Ìæ»»ËùÓоÉÎı¾¡£
Æß¡¢Rept: ²¹Î»º¯Êý
    •ÓÃ;: °´ÕÕ¸ø¶¨µÄ´ÎÊýÖØ¸´ÏÔʾÎı¾¡£¿ÉÒÔͨ¹ýREPTº¯Êý¶Ôµ¥Ôª¸ñ½øÐÐÖØ¸´Ìî³ä¡£
    •Óï·¨£ºRept(ÐèÒªÖØ¸´ÏÔʾµÄÎı¾£¬Öظ´ÏÔʾµÄ´ÎÊý)
    •²ÎÊý£ºÖظ´ÏÔʾµÄ´ÎÊýÐèҪΪÕýÊý¡£
°Ë¡¢NOW/TODAY(): ·µ»Øµ±Ç°ÈÕÆÚ
    •ÓÃ;: ·µ»Øµ±Ç°µçÄÔµÄÈÕÆÚºÍʱ¼ä
    •Óï·¨£ºNOW()

    •²ÎÊý£º´Ëº¯ÊýΪÎÞ²ÎÊýº¯Êý

    ±¾ÎÄÓÉÅàѵÎÞÓÇÍø´ïÄÚ½ÌÓý¿Î³Ì¹ËÎÊÀÏʦÕûÀí·¢²¼£¬¸ü¶à¿Î³ÌÐÅÏ¢¿É¹Ø×¢¼ÆËã»úµÈ¼¶Åàѵ»òÌí¼ÓÀÏʦ΢ÐÅ£º15033336050

      ×¢£º×ðÖØÔ­´´ÎÄÕÂ,×ªÔØÇë×¢Ã÷³ö´¦ºÍÁ´½Ó https://www.pxwy.cn/news-id-9717.html Î¥Õ߱ؾ¿£¡²¿·ÖÎÄÕÂÀ´Ô´ÓÚÍøÂçÓÉÅàѵÎÞÓÇÍø±à¼­²¿ÈËÔ±ÕûÀí·¢²¼,ÄÚÈÝÕæÊµÐÔÇë×ÔÐкËʵ»òÁªÏµÎÒÃÇ£¬Á˽â¸ü¶àÏà¹Ø×ÊѶÇë¹Ø×¢¼ÆËã»úµÈ¼¶ÆµµÀ²é¿´¸ü¶à£¬Á˽âÏà¹Ø×¨Òµ¿Î³ÌÐÅÏ¢Äú¿ÉÔÚÏß×ÉѯҲ¿ÉÃâ·ÑÉêÇëÊԿΡ£¹Ø×¢¹Ù·½Î¢ÐÅÁ˽â¸ü¶à£º150 3333 6050

ÁôÏÂÄãµÄÐÅÏ¢,¿Î³Ì¹ËÎÊÀÏʦ»áÒ»¶ÔÒ»°ïÖúÄã¹æ»®¸üÊʺÏÄãµÄרҵ¿Î³Ì!
  • ÐÕÃû£º

  • ÊÖ»ú£º

  • µØÇø£º

  • Ïëѧʲô£º

  • ÅàѵÎÞÓÇÍø
Ãâ ·Ñ Éê Çë ÊÔ Ìý
Ìá½»ÉêÇ룬¡¶ÅàѵÎÞÓÇÍø¡·¿Î³Ì¹ËÎÊÀÏʦ»áÒ»¶ÔÒ»°ïÖúÄã¹æ»®¸üÊʺÏÄãµÄרҵ¿Î³Ì£¡