ªð¦^¦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 : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD