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

[µo°Ý] »¼¼W±Æ§ÇA1~A10¡A¦p¦óÅýA1«á­±¬OA2¦Ó¤£¬OA10¡C

¦^´_ 1# av8d
°ò¥»¤W¸ê®Æ§t¦³«D¼Æ­È¦r¤¸®É¡A´N¥H¤å¦r±Æ§Ç¡A­n¥H¼Æ­È±Æ§Ç¥²¶·¥[»²§UÄæ¦ì¨ú±o¼Æ­È¡AµM«á¥H¸Ó»²§UÄæ¦ì±Æ§Ç

    Sort.rar (8.53 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-8-19 23:02 ½s¿è

¦^´_ 8# av8d
G2=--SUBSTITUTE(A2,MID(A2,1,LOOKUP(2,1/ISERROR(--MID(A2,ROW(INDIRECT("A1:A"&LEN(A2))),1)),ROW(INDIRECT("A1:A"&LEN(A2))))),"")
play.gif
2012-8-19 23:02
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 10# av8d
¤£½×¦p¦ó¡A´N¬O­n¨Ï¥Î»²§UÄæÂ^¨ú¥X¼Æ­È³¡¤À¦A¥h±Æ§Ç¡A¤~¯à¹F¨ì§Aªº»Ý¨D
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD