EXCELä¸æç»è®¡åèæ°çå½æ°ï¼å¯ä»¥ç¨LENBæ¥ç»è®¡åèæ°ã
è½¯ä»¶å·¥å ·ï¼Excel 2013
1ãLENB(text)è¿åææ¬å符串ä¸ç¨äºä»£è¡¨å符çåèæ°ã(text)æ¯å¿ éè¦çåæ°ï¼è¦æ¥æ¾å ¶é¿åº¦çææ¬ã
2ãLENB(text)ç»è®¡æå®åå æ ¼çåèæ°ï¼ä¸æå符æ¶è¿å两个åèï¼ç©ºæ ¼ä¹å°ä½ä¸ºå符è¿è¡è®¡æ°ã
3ã示ä¾ï¼LENB(B2)两个ä¸æåè¿å4个åèï¼LENB(B5)ä¸ä¸ªè±æ符å·åä¸æ符å·è¿å3个åèï¼LENB(B6)ä¸æä¸¤ä¸ªç©ºæ ¼ä¹ç®2个åèã
ç¸ä¼¼å½æ°LEN(text)ãLEN è¿åææ¬å符串ä¸çå符个æ°ãä¸ä¸ªä¸æåªç®ä¸ä¸ªå符ã两è çåºå«å¨äºä¸ä¸ªç»è®¡åèæ°ï¼ä¸ä¸ªç»è®¡å符æ°ãä¸ä¸ªä¸æå符çäºä¸¤ä¸ªåèãåªæå¨å° DBCS è¯è¨è®¾ç½®ä¸ºé»è®¤è¯è¨æ¶ï¼å½æ° LENB æä¼å°æ¯ä¸ªå符æ 2 个åè计æ°ã å¦åï¼å½æ° LENB çè¡ä¸ºä¸ LEN ç¸åï¼å³å°æ¯ä¸ªå符æ 1 个åè计æ°ã