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

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

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

¦bA1¥´   HGH5458   B1·|¥XHGH   C1¥X 5458
§â­^¤å©M¼Æ¦r¤À¶}.
½Ð°Ý¦³¤°»ò¨ç¼Æ¥i¥H°µ¨ì?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¬O§_©T©w¦r¸`¼Æ¡H

TOP

¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

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

B1=LEFT(A1,MIN(FIND(ROW($1:$10)-1,A1&"1234567890"))-1) °}¦C¤½¦¡
C1=LOOKUP(9.9E+307,--RIGHT(A1,ROW($1:$20)))

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-9-13 11:24 ½s¿è

¦^´_ 2# oobird


    ¤£©T©w¦r¸`¼Æªº.
EG.  
GF6.. G90..JOUJJ9089
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

B1=SUM(MID(A1,LARGE(IF(ISNUMBER(--MID(A1,ROW($1:$99),1)),ROW($1:$99)),ROW(INDIRECT("1:"&COUNT(--MID(A1,ROW($1:$99),1))))),1)*10^ROW(INDIRECT("1:"&COUNT(--MID(A1,ROW($1:$99),1))))/10) °}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-9-13 13:45 ½s¿è

¦^´_ 4# ANGELA


    ÁÂÁÂANGELA¤j¤j^^
¬°¤°»ò
B1=LEFT(A1,MIN(FIND(ROW($110)-1,A1&"1234567890"))-1) °}¦C¤½¦¡
C1=LOOKUP(9.9E+307,--RIGHT(A1,ROW($120)))

row­n 1:10 ? 1:20?
¥i¥H 1:1¶Ü?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

b1=LEFT(A1,LEN(A1)-(SUM(LEN(A1)-LEN(SUBSTITUTE(A1,{"0","1","2","3","4","5","6","7","8","9"," "},"")))))
c1=SUBSTITUTE(A1,B1,"")
´¶³q¤½¦¡

TOP

¦^´_ 8# oobird

ÁÂÁ¶W¯Åª©¥D^^
¦³´¶³q¤½¦¡¯u¦n><
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

½Ð±Ðoobird ª©¥D,¤£¤F¸Ñ b1¤½¦¡ªº·N«ä.¥i§_¸ÑÄÀ¤@¦¸.ÁÂÁÂ...
¥t¥~,¬°¦ó¬O¥Î{"0","1","2","3","4","5","6","7","8","9"," "}
joyce

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD