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

§Q¥ÎExcel¤ñ¹ï¦hµ§¦³¤À¹j²Å¸¹¸ê®Æªº¬Û¦P³B

¦^´_ 4# p212


    p212;
             ÁÂÁ§A¸Ñµª,¯à¥Î©TµM«Ü¦n¦ý§Ú·Q¤F¸Ñ¤½¦¡ªº§t·N³o¼Ë¤~¥i¥H¤é·s¶V·s¤£Â_¶i¨B©Ò¥H§Ú¦³¤U¦C°ÝÃD
1¡BLEN(D2)¡G­pºâD2Àx¦s®æ­ì¦³¦r¼Æ-------
ask:¬°¦ó­n¥ýºâÀx¦s®æ­ì¦³¦r¼Æ??D2Àx¦s®æ¬O"U1"©Î"C2,C3,C4,C5"³o¥i¥Hºâ¶Ü??¨º¬°¦ó­n¤U¦C²Ä2³¡"§R°£D2Àx¦s®æ¤¤ªº³r¸¹¨Ï¦r¦ê¬°³sÄò¤£
¤¤Â_"

2¡BSUBSTITUTE(D2,",","")¡G§R°£D2Àx¦s®æ¤¤ªº³r¸¹¨Ï¦r¦ê¬°³sÄò¤£¤¤Â_

ask:­Y¤£§R°£¦s®æ¤¤ªº³r¸¹¨Ï¦r¦ê¬°³sÄò¤£¤¤Â_¬O§_¥iª½±µ°õ¦æ¤U¦C²Ä3¨B

3¡BLEN(SUBSTITUTE(D2,",",""))¡G­pºâ§R°£D2Àx¦s®æ¤¤ªº³r¸¹«á³sÄò¦r¦êªº¦r¼Æ

ask:¤W¦C³o¨Ç¤½¦¡¬O©T©wªº¨BÆJ¶Ü??ÁÙ¬O¥i¥H¹³C»y¨¥¤@¼Ë¦³»yªk©Î¥i²¤Æµ{¦¡??

ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-9 09:45 ½s¿è

¦^´_ 11# parker
°²³]¡G«ü©wÀx¦s®æD2¤º¦r¦ê¬°¡uC2,C3,C4,C5¡v
¤ÀªR¡G¦r¦ê¡uC2,C3,C4,C5¡v©Ò¦³¦r¤¸­Ó¼Æ¬°¡u11¡v¡A¤£§t³r¸¹¤§¦r¤¸­Ó¼Æ«h¬°¡u8¡v¡A³r¸¹­Ó¼Æ¬°¡u3¡v¡C
1¡B±ý­pºâ¦r¦ê¤º§t©Ò¦³¦r¤¸­Ó¼Æ¡A«h¿ï¥Î¤å¦rÃþ¨ç¼ÆLEN(text)¡A§Y LEN(D2)=11¡C
2¡B¤µ±ý­pºâ¥X¤£§t³r¸¹¤§¦r¤¸­Ó¼Æ¡A«h»ÝÂǥΤå¦rÃþ¨ç¼ÆSUBSTITUTE(text,old_text,new_text,instance_num)¨Ó±Æ°£³r¸¹¡C
¦p¦b«ü©wÀx¦s®æD2¤º¦r¦ê¡uC2,C3,C4,C5¡v¡Aold_text§Y¬O¹ïÀ³¨ì¡u,¡v¡Anew_text«h¥Î¡u""¡v¥HµL¶¡¹j¨ú¥N¡u,¡v¡A¦p¦¹SUBSTITUTE(D2,",","")µ²ªG¦^À³¬°¡uC2C3C4C5¡v¡C
3¡B¹ïSUBSTITUTE(D2,",","")ªºµ²ªG¦A¦¸®M¥ÎLEN(text)¨ç¼Æ¡A§YLEN(SUBSTITUTE(D2,",",""))=LEN(C2C3C4C5)=8¡C
4¡B¬G«ü©wÀx¦s®æD2³r¸¹­Ó¼Æ=LEN(D2)-LEN(SUBSTITUTE(D2,",",""))=11-8=3
5¡B­Y¤µ±ý­pºâ³Q³r¸¹°Ï¹j¶}¨Óªº¦r¦ê¡A«h¶È¹ï¡u³r¸¹­Ó¼Æ¡v¦A¥[¤W¡u1¡v§Y¥i¸Ñ¨M¡C(©Ó¤W°²³]¬°C2¡BC3¡BC4»PC5¡A¦r¦ê­Ó¼Æ¬°3+1=4¡C)

¥H¤W¸Ñ»¡½Ð°Ñ¦Ò¡I
ps.¥»¤H±q¥¼¾Ç¹LC»y¨¥¡A¥H¤W¶È´NÅÞ¿è«ä¦Ò¦Ó±o¡C

TOP

¦^´_ 12# p212


    ¨ü±Ð¨ü±Ð,¤F¸Ñ¤F
ÁÂÁÂ

TOP

¯u¬O¾Ç¨ì¤F ~"~ ÁÂÁ¤À¨É
ewdas

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD