![]() ![]() |
|
·Î±×ÀÎ
°¡ÀÔ
|
¿¢¼¿¿¡¼ ÇÑ ¼¿ ¾È¿¡ ƯÁ¤±ÛÀÚÀÇ °¹¼ö¸¦ ¼¼´Â ¹æ¹ý | |
ÀÌ ¸§ | °»ç ![]() |
Á¶ ȸ | 1,943 |
¸µ Å© #1 | http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=102020101&docId=113629285&qb=7JeR7IWAIOq4gOyekOqwr+yImA==&enc=utf8§ion=kin&rank=4&search_sort=0&spq=0&pid=gKIPHz331ylsst19baRssv--372238&sid=TM6ebV |
±ÛÀÚÅ©±â | ![]() ![]() |
substituteÇÔ¼öÀÇ ÀÀ¿ëÀÔ´Ï´Ù.
AC8 ¿¡ =len(F8) - len(substitute(F8,",","")) + 1 À» ÀÔ·ÂÇÏ½Ã¸é µË´Ï´Ù. lenÇÔ¼ö : ¹®ÀÚ¿ ±æÀÌ ±¸ÇÏ´Â ÇÔ¼ö substitute(¼¿¹øÈ£,"¹®ÀÚ¿1","¹®ÀÚ¿2") : ´ë»ó¼¿¿¡¼ ¹®ÀÚ¿1À» ã¾Æ ¹®ÀÚ¿2·Î ¹Ù²Ù¾î ÁÖ´Â ÇÔ¼ö À§¿¡¼ substitute(F8,",","") : f8ÀÇ ³»¿ëÁß ,¸¦ Áö¿ì¶ó´Â ÀǹÌÀÓ ,(ÄÞ¸¶)´Â µ¥ÀÌÅͼöº¸´Ù Çϳª°¡ ÀûÀ¸¹Ç·Î +1 |
|
![]() |
|
![]() |
ºÐ·ù
¢Ãppt (0)
¢ÃVc++ (2)
|
|
Copyright 1999-2025 Zeroboard / skin by SIRINI |