ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¨ç¼Æ°ÝÃD

¥t¤@­Ó°}¦C¤½¦¡
b1=LEFT(A1,LEN(A1)-SUM(ISNUMBER(--RIGHT(A1,ROW($1:$100)))*1))
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

®æ¦¡³£¬O¦r¥À3¦ì¼Æ¦r4¦ì,¥Î¸ê®Æ­åªR.

B1=LEFT(A1,MIN(FIND(ROW($110)-1,A1&"1234567890"))-1) °}¦C¤½¦¡ ...
ANGELA µoªí©ó 2010-9-13 10:05



ANGELA ¨Ï¥Îfind¨ç¼ÆÅý¤H¦Õ¥Ø¤@·s
¥©§®¹B¥Î"1234567890"ÁקK²£¥Í¿ù»~
¬O¤£¿ùªº¸Ñªk
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

´N¬O§â©Ò¦³¬Ý¦ü¼Æ¦rªº¦r²Å¤ÎªÅ®æ³£®ø°£«á³Ñ¤Uªº´N¬O¦r¥À¤F¡C

TOP

=LEFT(A1,LEN(A1)-(SUM(LEN(A1)-LEN(SUBSTITUTE(A1,{"0","1","2","3","4","5","6","7","8","9"," "},"")))))
±qA1ªº¥ªÃä¨úA!Á`ªø«×´î¥h©Ò¦³§ä¨ì0~9¤ÎªÅ¥Õªº¼Æ¶qªº¦ì¼Æ.
6F¬O°}¦C¤½¦¡¥i§ä¨ì¥ô¦ó¤£³W«hªº¼Æ¦r.

TOP

b1=MID(A1,1,FIND({"1","2","3","4","5","6","7","8","9","0"},A1)-1)
c1=MID(A1,FIND({"1","2","3","4","5","6","7","8","9","0"},A1),99)
joviwang

TOP

¹ï¤£°_¡A¤W¤@©«¥u¯à§ä¨ì1¦Ó¤w¡A
¤£¬O­Ó¥¿½Tªº¸Ñªk¡A½Ð§R°£¡C
joviwang

TOP

¦pªG©T©w¦r¸`¬O¤£¬O´N¥i¥H¥Î¸ê®Æ­åªR¨Ó§¹¦¨¡I

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD