ãã¤ãå¿ããã®ã§ã¡ã¢ãã¾ãã ã¨ã¯ã»ã«ã§ç¹å®ã®æåã®åã¾ã§ãåãåºããç¹å®ã®æå以éãåãåºãæ¹æ³ã§ãã ç¹å®ã®æåã®åã¾ã§ãåãåºã ããããã㨠ä¸è¨ã®ãããªæååããããããã£ã¦ãã«ãã³ã®åã¾ã§åãåºãããå ´å ãç¥ãã(23) æ¥è¨(384) ãè©«ã³(2564) ç«(15048) âãããããã ãç¥ãã æ¥è¨ ãè©«ã³ ç« æ¸ãæ¹ï¼A1ã«æååãããä¾ï¼ =LEFT(A1,FIND("(",A1)-1) 説æ LEFTã¯å
é ããæå®ãããã¨ããã¾ã§åãåºããé¢æ°ã LEFT(æåå, æåæ°) =LEFT("ãç¥ãã(23)", 4) ã¨ããã¨ãå
é ãã4æåç®ã¾ã§ã®ããç¥ããããåãåºããã FINDã¯æ¤ç´¢ããæåãæååã®ä½çªç®ã«æåã«åºã¦ããããåãåºããé¢æ°ã FIND(æ¤ç´¢æåå, 対象, [éå§ä½ç½®]) =FIND("(", "ãç¥ãã(23)") ã¨ããã¨ã(ãããã
{{#tags}}- {{label}}
{{/tags}}