å设æ°æ®å¨Aåï¼å¦ä¸å¾ï¼
åB1è¾å ¥ä¸å¾çå ¬å¼åä¸æå¤å¶å¡«å ï¼ç»æå¦ä¸å¾ï¼
=RIGHT(A1,LEN(A1)*2-LENB(A1))
å ¬å¼è§£æï¼
LENå½æ°æ¯è¿åå符串çé¿åº¦ï¼ä¸ç®¡æ¯ååèè¿æ¯ååèé½è®¡ä¸º1ï¼
LENBå½æ°æ¯è¿åå符串çé¿åº¦ï¼ååè计为2ï¼ååè计为1ï¼
ä¸æå符é½æ¯ååèï¼èå¾çä¸çé¿æ伯æ°ååå°æ°ç¹é½æ¯ååèï¼å æ¤ç¨LEN*2-LENBå°±æ¯æ°å+å°æ°ç¹çä½æ°ã
ç¥è¯æ©å±ï¼
æ¬ä¾ä¸ï¼æä¸ä¼ çå¾çä¸ï¼äºãä¸çº§ç§ç®åå æ ¼åé¢æ¯æ²¡æç©ºæ ¼çï¼ä½¿ç¨åå æ ¼ç¼©è¿æ¥è§£å³ä¸å级å«ç§ç®é´ç缩è¿ï¼ï¼èç©ºæ ¼ä¹æ¯ååèï¼å¦æä¸æ¯ä½¿ç¨ç¼©è¿ï¼èæ¯ä½¿ç¨ç©ºæ ¼æ¥è°æ´ç¼©è¿ï¼åå ¬å¼ä¸å¯ä»¥å¢å TRIMå½æ°æ¥æ¸ é¤ç©ºæ ¼ï¼
=RIGHT(TRIM(A1),LEN(TRIM(A1))*2-LENB(TRIM(A1)))
说æï¼
TRIMå½æ°æ¯æ¸ é¤å符串ååçç©ºæ ¼ï¼ä¸å å«ä¸é´çç©ºæ ¼ï¼ï¼å¦=TRIM(" å° æ¹ ")="å° æ¹"ï¼ä¸é´çç©ºæ ¼ä¸æ¸ é¤ã