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

·j¯Á°Ï¶¡¤º¦r¦êªº¦¸¼Æ

·j¯Á°Ï¶¡¤º¦r¦êªº¦¸¼Æ

¦p¦ó·j¯ÁÄæ¦ì¤º¦r¦ê¥X²{ªº¦¸¼Æ?
¨Ò¦p¦bA1~A2ªº°Ï¶¡¸Ì¦³2¦ê¦r
A1 ¥Ò¥Ò¥Ò¤A¤þ¤B
A2 ¥Ò¤A¤þ¤þ¤þ¤B

¦³­þ­Ó¨ç¼Æ©Î¤°»ò¤èªk¥i¥H¦bC1Äæ¦ì¸Ì­pºâ¥X"¥Ò"¥X²{´X¦¸;"¤A"¥X²{´X¦¸¶Ü?
§Úª¾¹D·j¯Á¥i¥H°µ¨ì,¦ý§Ú·Q§â¥LÅã¥Ü¦¨¤@­Óªí®æ!

¦^´_ 4# kate1982
¹ï¡I¦ý¦pªGı±o³o¼Ë¦êÁp¤Óªø¡A¨º´N§ï¦¨
LEN(PHONETIC($A$1:$A$20))-LEN((SUBSTITUTE(PHONETIC($A$1:$A$20),"¥Ò","")))
§Æ±æ¦³À°§U¨ì§A

TOP

¨º¦pªG§Úªº°Ï¶¡¥ÑA1~A20¬O¤£¬O­n±q$A$1&$A$2&$A$3..........&$A$20©O?

TOP

¤Ó·PÁ¤F,³o¼Ë§Ú´N¤£¥Î¦A¤@­Ó¤@­Ó·j¯Ákey¤W¥h¤F,²×©óT_T
ÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂÁÂ

TOP

¦^´_ 1# kate1982
¤p©fÄmÁà¤F¡A¤]³\¦³§ó²²¤ªº¼gªk«Ý°ª¤H«üÂI¡A
¥Ò¥X²{¦¸¼Æ=LEN($A$1&$A$2)-LEN(SUBSTITUTE($A$1&$A$2,"¥Ò",""))
¤A¥X²{¦¸¼Æ=LEN($A$1&$A$2)-LEN(SUBSTITUTE($A$1&$A$2,"¤A",""))

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD