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

¦p¦ó²Î­pÀx¦s®æ¤º , ¦P¤@¦r¦ê¥X²{¤§¦¸¼Æ©O?

¦p¦ó²Î­pÀx¦s®æ¤º , ¦P¤@¦r¦ê¥X²{¤§¦¸¼Æ©O?

¥dÃö¤F
½Ð°Ý­Y·Q­n§äÀx¦s®æ¤º, ¦³ "." ¤p¼ÆÂI¥X²{¦¸¼Æ , ­n¥Î¤°»ò«ü¥O°Ú....§ä¤£¨ì>"<
½Ð¦U¦ì¤j¤jÀ°¦£¤@¤U.  

A1.H3 U1.10 A1.H3 U1.10 A1.H3 U1.10 A1.H3 U1.10 A1.H3 U1.10
==> §Æ±æ¨D±o  10

=LEN(A1)-LEN(SUBSTITUTE(A1,".",))

TOP

ÁÂÁ , Excel ¯uªº¬O¾ÇµL¤î¹Ò°Ú....

TOP

¦^´_ 2# ANGELA


    ¡@ ³á³á!? ½Ð±Ð¤@¤U, ³o¬O¤°»ò?

¡@¡@·Q¦h¤F¸Ñ¬O¦p¦ó¨Ï¥Îªº, ¦ý¬OExcel»¡©ú¤¤ªºLEN¨ç¼Æ»¡©ú¤£¬O«Ü²z¸Ñ...
¤]¤£²M·¡SUBSTITUTE (¨ú¥N?)¥\¯à¦b³o­Ó¨Ò¤l¤¤¬O¦p¦ó¹B§@ªº;
§ä§t¦³A1ªº¦r¦ê, ·Ç³Æ¨ú¥N¥¦¸Ì­±ªº"."?

ÁÂÁÂ!

TOP

=LEN(A1)-LEN(SUBSTITUTE(A1,".",))
SUBSTITUTE(A1,".",) =SUBSTITUTE(A1,".","") ¬Ù¤F""¬O±NA1¤¤ªº " . "¥þ³¡¥Î""¨ú¥N,
¦³¦h¤Ö­Ó "."¦r¦êªø«×´N·|´î¦h¤Ö¡C

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD