EXCEL findãå³ãã(å¾ããã)æ¤ç´¢ããæ¹æ³ã¯ãããããããããªãï¼ æååé¢æ°ã®éæ¿ã§ããfindã§ãããé常ã¯å·¦ããã®æ¤ç´¢ããã§ããªãã§ãããã ãããå³ãã(å¾ããã)æ¤ç´¢ãæ®éã«ããã¨ã§ããªããã§ãã ããé¢æ°ãçµã¿åãããã°å³ç«¯ã®æåæ¤ç´¢ãã§ãããã§ãï¼ Find ã¾ãã¯é常ã®å·¦ããã 㨠ä»åã®ä¾ã¨ãã¦ãA3ã®æååãaaa-bbb-ccc-dddãã®æååãããã¤ãã³ã-ãã®æåä½ç½®ãåå¾ãã¾ãã é常ã®Findã§å·¦ããæ¤ç´¢ãè¡ã£ãã¨ãã«æ°å¼ã»çµæã¯ãããªãã¾ãã æ°å¼ï¼=FIND("-",A3) çµæï¼4 Findã§å³ããæ¤ç´¢ã¯ã©ãããã®ï¼ æååãããã¤ãã³ã-ãã®ä¸çªå³ã®ä½ç½®ãåå¾ãããã¨ãçµæã12ã«ãªãã¾ãã ãããFindã§åå¾ãããã¨ããããé¢æ°ã¨çµã¿åããããã¨ã§å¯è½ã«ãªãã¾ãã SUBSTITUTEé¢æ°ã¨LENé¢æ°ã使ã£ã¦ãå³ããæ¤ç´¢ãå¯è½ã« æ°å¼ï¼=
{{#tags}}- {{label}}
{{/tags}}