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

[µo°Ý] 2­Ó°ÝÃD

[µo°Ý] 2­Ó°ÝÃD

¥»©«³Ì«á¥Ñ oobird ©ó 2010-10-14 08:47 ½s¿è

1. SHEET1ªº¶i¶¥¿z¿ï¦³¨S¦³¨ä¥L¦nªº¤èªk¿z¿ï¥X P1-P4©MP6ªº©Ò¦³ªF¦è?
2. SHEET2 ¥i§_¦b D:D ¥u¥XA:Aªº¼Æ¦r?
½Ð¤j¤jÀ°§U.

BOOK1.rar (7.87 KB)

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X


SHEET2!D1=--LEFT(A1,LOOKUP(9.9E+307,--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),ROW(INDIRECT("1:"&LEN(A1)))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
ÁÂÁÂHsieh¶W¯Åª©¥D.
1ªº°ÝÃD.  §Ú³£¬O¥Î¶i¶¥¿z¿ï. ¦]¬°¦pªG­n§äP1-P9(9¼ËªF¦è)´N­n°µ9¦æROW,
½Ð°Ý¦³¨S¦³¨ä¥L¦nªº¤èªk¿z¿ï?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

=--IF(TYPE(RIGHT(A1,1)=2),SUBSTITUTE(A1,RIGHT(A1,1),""),A1)
¶i¶¥¿z¿ï¨S¬ÝÀ´¡A"¦]¬°¦pªG­n§äP1-P9(9¼ËªF¦è)´N­n°µ9¦æROW"????

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-10-14 10:51 ½s¿è

¦^´_ 4# oobird
ÁÂÁÂoobird¶W¯Åª©¥D.
=--IF(TYPE(RIGHT(A1,1)=2),SUBSTITUTE(A1,RIGHT(A1,1),""),A1)
¤§­Ó¦pªG¥u¬O¼Æ¦r·|¤Ö¤F1­Ó¦ì, eg, a1¥´ 10  d1¥u¥X 1.

°ÝÃD2
§ârow 3-6 del .
¦³¨S¦³¨ä¥L¦nªº¤èªk ¶i¶¥¿z¿ï¥XP1-P4©MP6ªº©Ò¦³ªF¦è.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 5# basarasy


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh

ÁÂÁÂHsieh¶W¯Åª©¥D.
¶i¶¥¿z¿ï¦³³o­Ó¤èªk¯uªº¤Ó¦n¤F.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD