AããZã¾ã§ãã¢ã«ãã¡ããããé£ç¶ãã¼ã¿ã¨ãã¦å
¥åãããå ´åããã¦ã¼ã¶ã¼è¨å®ãªã¹ããã«ç»é²ãã¦ããæ¹æ³ãèãããããããæååã®ã³ã¼ãçªå·ã調ã¹ãCODEé¢æ°ã¨ãã³ã¼ãçªå·ã«å¯¾å¿ããæååã調ã¹ãCHARé¢æ°ãçµã¿åããã¦ä½¿ãæ¹æ³ããããã¢ã«ãã¡ãããã®ã³ã¼ãçªå·ã¯ãAããããZãã¾ã§é ã«1ãã¤å¢ãã¦ããããã«ãªã£ã¦ããã®ã§ããããå©ç¨ããæ°å¼ãä½ãã®ã ã ãã¡ããããã®æ¹æ³ã¯ã¢ã«ãã¡ãããã®å°æåã®å ´åã«ãå¿ç¨ã§ãããããã²ãããªãã«ã¿ã«ãã®å ´åã¯ããããããããããããããããã®ãããªé ã«ä¸¦ãã§ããã®ã§ããã®ãã¯ããã¯ã¯ä½¿ããªãã â² ã»ã«A1ã«ãAãã¨å
¥åããããã»ã«A2ã«ã=CHAR(CODE(A1)+1)ãã¨å
¥åããããã®æ°å¼ã¯ãã»ã«A1ã«å
¥åããããAãã®ã³ã¼ãçªå·ãCODEé¢æ°ã§èª¿ã¹ãããã«ã1ãã足ãã¦ããCHARé¢æ°ã§åã³ãã®ã³ã¼ãçªå·ã«å¯¾å¿ããæååã表示ãããæå³ã
{{#tags}}- {{label}}
{{/tags}}