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

±N¼Æ¦r»P­^¤å¦r¥[¤WªÅ®æ¤À¶}

±N¼Æ¦r»P­^¤å¦r¥[¤WªÅ®æ¤À¶}

½Ð°Ý¥i¥H±N­^¤å¦r»P¼Æ¦r¤§¶¡¥[¤WªÅ®æ¤À¶}¶Ü?
¦p: girl123 ¦¨¬° girl 123
    boy45 ¦¨¬° boy 45

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-8-31 10:10 ½s¿è

¦^´_ 1# enoch

=SUBSTITUTE(A1,RIGHT(A1,SUMPRODUCT(ISNUMBER(--MID(A1,ROW(1:255),1))*1))," "&RIGHT(A1,SUMPRODUCT(ISNUMBER(--MID(A1,ROW(1:255),1))*1)))
©Î
=REPLACE(A1,LOOKUP(1,1/(CODE(MID(A1,ROW($1:$255),1))>=65)*(CODE(MID(A1,ROW($1:$255),1))<=122),ROW($1:$255))+1,," ")
1

µû¤À¤H¼Æ

    • gong: ¤£¥Î°}¦C¤½¦¡¤]¬O¥i¥Hº}«G§¹¦¨ª÷¿ú + 2
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2011-8-30 23:00 ½s¿è

{=REPLACE(A1,MATCH(1,--ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1)+1)),1)),),," ")}
©Î
{=REPLACE(A1,MATCH(1,--ISNUMBER(--MID(A1,ROW(1:255),1)),),," ")}
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

´ê­Ó¼ö¾x,
=REPLACE(A1,MATCH(1=1,CODE(MID(A1,ROW(1:99),1))<64,),," ")
°}¦C¤½¦¡
1

µû¤À¤H¼Æ

    • gong: 1=1 ¥Îªº¤Ó§®¤Fª÷¿ú + 2

TOP

¥»©«³Ì«á¥Ñ enoch ©ó 2011-9-9 15:15 ½s¿è

¦hÁ¦U¦ì°ª¤â½ç±Ð, ¹ê¦b¤Ó¦h¤èªk¤Î¤Ó²`¶ø, »Ý­nºCºC®ø¤Æ
¤@ª½¥H¨Ó, §Ú¥uª¾°}¦C¤½¦¡¥u¥Î©ó¤@­Ó½d³ò, ¦ô­ø¨ì¥i¥H¥Î©ó³æ¤@Àx¦s®æ, ¤Ó©_§®

·Q½Ð±Ð
=REPLACE(A1,MATCH(1=1,CODE(MID(A1,ROW(1:99),1))<64,),," ")
¤¤ªº 1=1 ¥Nªí¬Æ»ò?

{=REPLACE(A1,MATCH(1,--ISNUMBER(--MID(A1,ROW(1:255),1)),),," ")}
¤¤ªº--¤S¥Nªí¬Æ»ò?

¥t¥~­Y­^¤å»P¼Æ¦r¤£¥u¬O³Ì«e¦ì¸m, ¦Ó¬O¤@¬q¤å¦r¤¤¤£©T©w¨ä¥L¦ì¸m³£¥X²{³o±¡ªp
¨Ò¦p 123abc 45de de458
Åܦ¨ 123 abc 45 de de 458
¥i¥H¥Î¤½¦¡©Îvba³B²z¶Ü?
½Ð¦A«ü±Ð

TOP

¦^´_ 5# enoch
¤£©w¦¸¼Æ«Øij¨Ï¥Î¦Û©w¸q¨ç¼Æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh

¦hÁ«ü±Ð

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD