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

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

¥»©«³Ì«á¥Ñ 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

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

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD