oobird

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¤½¦¡

basarasy

¦^´_ 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¶Ü?

ANGELA

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¤½¦¡

basarasy

¦^´_ 2# oobird


    ¤£©T©w¦r¸`¼Æªº.
EG.  
GF6.. G90..JOUJJ9089

ANGELA

®æ¦¡³£¬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)))

PD961A

¦^´_ 1# basarasy


    http://forum.twbts.com/viewthread.php?tid=1112&extra=page%3D5

oobird

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