ÔÚѧϰexcelÕâÒ»±í¸ñ¹¤¾ßµÄʱºò£¬ºÜ¶àÍøÓѶ¼»áËÑË÷һЩexcelµÄ½Ì³Ì£¬¶øÆäÖУ¬×î¶àÈËËÑË÷µÄ¾ÍÊǹØÓÚexcelº¯ÊýµÄÔËÓõĽ̳̣¬ÒòΪѧ»áexcelº¯ÊýµÄÔËÓ㬽«ºÜ´óµÄÌá¸ß±í¸ñÖÆ×÷µÄЧÂÊ£¬
¡£½ñÌìС¡¢Ð¡±à¾ÍΪ´ó¼Ò·ÖÏíÒ»ÏÂexcel2¸ö¼òµ¥µÄº¯Êý¹«Ê½leftÓërightµÄʹÓ÷½·¨£¬Ï£Íû´ó¼Òϲ»¶!
1.Ê×ÏÈÎÒÃÇ´ò¿ªÒ»Õűí¸ñ£¬ÔÚ±í¸ñÖÐËæ±ãÊäÈëһЩÊý¾Ý£¬ÎÒÊäÈëµÄÊý¾ÝÈçͼËùʾ(µ±È»´ó¼ÒÒ²¿ÉÒÔ×Ô¼ºµÄÊäÈëһЩÈÕÆÚ»òÕßÊÇÎÄ×Ö£¬·½·¨ÊÇÒ»ÑùµÄ½á¹û¾Í»áÒ»Ñù¡£
2.Ñ¡ÖÐÒ»¸ö¿ÕµÄµ¥Ôª¸ñ£¬´Ëµ¥Ôª¸ñÊÇÓÃÀ´ÔËÓÃLEFTº¯ÊýÎÒÃÇ·ÖÀë³öÀ´µÄÊý¾ÝÉú³ÉµÄµ¥Ôª¸ñ£¬ÈçͼTextÊÇÒªÌáÈ¡×Ö·ûµÄµ¥Ôª¸ñ£¬Num_charsÊÇÖ¸´ÓÑ¡Öеĵ¥Ôª¸ñÖдÓ×óÊýµÄ¼¸Î»×Ö·û£¬Í¼ÖÐÊÇÖ¸´ÓA1µ¥Ôª¸ñÖÐ×óÊý2λ×Ö·û¡£
3.Óɵڶþ²½²Ù×÷¹«Ê½ºó£¬ÎÒÃǵóöÀ´ÏÂÃæµÄ½á¹ûÈçͼ£¬ A1µ¥Ôª¸ñÖдÓ×óÊý2λ×Ö·ûÊÇ40¾ÍÏñÎÒÃÇ¿´µ½µÄȷʵ¾ÍÊÇ40£¬
¡¶
excelº¯ÊýleftÓërightµÄʹÓý̡̳·(
https://www.unjs.com)¡£
4.right¹«Ê½µÄʹ¸úleft¹«Ê½»ù±¾ÊÇÏàͬµÄ£¬ËüÃǶÔÐèÒª·ÖÀëµÄµ¥Ôª¸ñµÄÒªÇóÊÇÒ»ÑùµÄ£¬²»Í¬µÄÊǹ«Ê½ÖУºNum_charsÊÇÖ¸´ÓÑ¡Öеĵ¥Ôª¸ñÖдÓÓÒÊýµÄ¼¸Î»×Ö·û£¬ÏÂÃæÊÇÖ±½Ó´Óright¹«Ê½¿ªÊ¼·ÖÎö£¬ÈçͼÖеĹ«Ê½Ëùʾ£¬
5.ÓÉright¹«Ê½²Ù×÷ºó³ÊÏÖ³öÀ´µÄ½á¹ûÈçͼËùʾ£¬A1ÊÇÐèÒª·ÖÀëµÄµ¥Ôª¸ñ£¬2ÊÇÖ¸´ÓA1µ¥Ôª¸ñÓÒÊýµÄ2λ×Ö·û£¬½á¹û¾ÍÊÇÎÒÃÇ¿´µ½µÄ66£¬Õâ¸öÊǾÍÕâ2¸ö¹«Ê½¼òµ¥µÄÔËÓã¬Ï£Íû¿ÉÒÔ°ïæµ½´ó¼Ò
×¢ÒâÊÂÏ right¹«Ê½Óëleft¹«Ê½´ó¼ÒÔÚʹÓõÄʱºòҪעÒⲻҪŪ»ìÁË£¬¹«Ê½µÄÇ°²¿·ÖÊÇÒ»ÑùµÄ£¬µ«ÊÇËüÃÇÊÇ´ÓÑ¡Öе¥Ôª¸ñµÄ²»Í¬±ß¿ªÊ¼ÊýµÄÕâµã´ó¼ÒÒ»¶¨Òª×¢Òâ¡£
ÒÔÉϾÍÊÇexcelÖÐ2¸ö¹«Ê½leftÓërightÔÚ±í¸ñÖеÄÔËÓÃÏê½â£¬Ï£ÍûÄܶԴó¼ÒÓÐËù°ïÖú!