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

[µo°Ý] excel ³æ¤@Àx¦s®æ¤º¼Æ¦r¥X²{¦¸¼Æ

[µo°Ý] excel ³æ¤@Àx¦s®æ¤º¼Æ¦r¥X²{¦¸¼Æ

¥»©«³Ì«á¥Ñ la1975 ©ó 2013-12-25 14:38 ½s¿è

excel ¤¤³æ¤@Àx¦s®æ¤º¼Æ¦r¥X²{¦¸¼Æ (¨ç¼Æ)

excel ³æ¤@Àx¦s®æ¤¤¦p¦ó­pºâ ¼Æ¦r¥X²{ªº¦¸¼Æ(¼Æ¦r¦³³rÂI¹j¶})

ex: 12,43,63,96,01,96,05,01

¦p¦ó­pºâÁ`¦@¥X²{¤F´X­Ó¼Æ¦r?

¥»©«³Ì«á¥Ñ p212 ©ó 2013-12-25 15:01 ½s¿è

¦^´_ 1# la1975
°²³]Àx¦s®æA1=12,43,63,96,01,96,05,01
(1)­pºâ¥X²{ªº¡u³rÂI¡v­Ó¼Æ¡AÀx¦s®æB1=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))
(2)­pºâ¥X²{ªº¡u¼Æ¦r¡v­Ó¼Æ¡AÀx¦s®æB1=LEN(SUBSTITUTE(A1,",",""))
 ½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212


    °²³]Àx¦s®æA1=12,43,63,96,01,96,05,01

(2)­pºâ¥X²{ªº¡u¼Æ¦r¡v­Ó¼Æ¡AÀx¦s®æB1=LEN(SUBSTITUTE(A1,",",""))   ¬°¤°»ò¡H¬O16ªü...

TOP

¥»©«³Ì«á¥Ñ owen06 ©ó 2013-12-26 08:28 ½s¿è

¦^´_ 3# la1975


    ªü¤W­±ªº¼Æ¦r¤£´N¬O16­Ó¶Ü¡K
    ÁÙ¬O§A¬O­nºâ¥X²{"´X²Õ"¼Æ¦r¡H

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD