§Q¥ÎExcel¤ñ¹ï¦hµ§¦³¤À¹j²Å¸¹¸ê®Æªº¬Û¦P³B
- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-10-6
- ³Ì«áµn¿ý
- 2013-11-14
|
¦^´_ 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)¡Gpºâ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,",",""))¡Gpºâ§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²¤Æµ{¦¡??
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ 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¡BY¤µ±ý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 |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 9
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-10-6
- ³Ì«áµn¿ý
- 2013-11-14
|
¦^´_ 12# p212
¨ü±Ð¨ü±Ð,¤F¸Ñ¤F
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 1
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1
- ÂI¦W
- 0
- §@·~¨t²Î
- vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- ¨Ó¦Û
- dddasdasdsa
- µù¥U®É¶¡
- 2013-10-11
- ³Ì«áµn¿ý
- 2013-10-11
|
|
ewdas
|
|
|
|
|