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

enoch

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

Hsieh

¦^´_ 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,," ")

gong

{=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)),),," ")}

ANGELA

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

enoch

¦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«ü±Ð

Hsieh

¦^´_ 5# enoch
¤£©w¦¸¼Æ«Øij¨Ï¥Î¦Û©w¸q¨ç¼Æ

¤U¸ü (17.23 KB)

2011-9-10 09:49

enoch

Hsieh

¦hÁ«ü±Ð