{"author_url":"https://blog.hatena.ne.jp/ell104/","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fell104.hatenablog.jp%2Fentry%2F2011%2F06%2F05%2F115405\" title=\"\uff25\uff58\uff43\uff45\uff4c\u95a2\u6570\u30fb\u30fb\u30fb\uff23\uff28\uff21\uff32\u30fb\uff23\uff2f\uff24\uff25\u95a2\u6570\uff08\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u3092\u9023\u7d9a\u30c7\u30fc\u30bf\u3068\u3057\u3066\u5165\u529b\uff09 -  ELL\u306e\u8db3\u8de1\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","width":"100%","provider_url":"https://hatena.blog","blog_title":" ELL\u306e\u8db3\u8de1","height":"190","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/e/ell104/20250427/20250427141849.jpg","blog_url":"https://ell104.hatenablog.jp/","url":"https://ell104.hatenablog.jp/entry/2011/06/05/115405","author_name":"ell104","version":"1.0","title":"\uff25\uff58\uff43\uff45\uff4c\u95a2\u6570\u30fb\u30fb\u30fb\uff23\uff28\uff21\uff32\u30fb\uff23\uff2f\uff24\uff25\u95a2\u6570\uff08\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u3092\u9023\u7d9a\u30c7\u30fc\u30bf\u3068\u3057\u3066\u5165\u529b\uff09","categories":["\u65e5\u3005\u306e\u30d1\u30bd\u30b3\u30f3"],"description":"\u4eca\u65e5\u306fExcel\u3067\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u3092\u6570\u5b57\u306e\u69d8\u306b\u9023\u7d9a\u3057\u305f\u30c7\u30fc\u30bf\u3068\u3057\u3066\u5165\u529b\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u306d\u30fb\u30fb\u30fb\u4ee5\u524d\u7d39\u4ecb\u3057\u305f\u6587\u5b57\u306e\u30b3\u30fc\u30c9\u3092\u8868\u793a\u3059\u308b\u95a2\u6570CODE\u95a2\u6570\u3068\u30b3\u30fc\u30c9\u3092\u6587\u5b57\u306b\u3059\u308bCHAR\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u305d\u308c\u3067\u306f\u8aac\u660e\u3057\u3066\u307f\u307e\u3059\u306d\u30fb\u30fb\u30fb \u30bb\u30ebA1\u306b \"A\" \u3068\u5165\u529b\u3055\u308c\u3066\u307e\u3059 \u30bb\u30ebA2\u306b\u30bb\u30ebA1\u306b\u5165\u529b\u3055\u308c\u3066\u308b\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u306e\u30b3\u30fc\u30c9\u3092\u8abf\u3079\u307e\u3059\u30fb\u30fb\u30fb =CODE(A1) \u30bb\u30ebA2\u306b\u5165\u308b\u3079\u304d\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u306f\u30bb\u30ebA1\u306b\u8a18\u5165\u3055\u308c\u3066\u308b \"A\" \u306e\u6b21\u306e \"B\" \u3092\u5165\u308c\u305f\u3044\u306e\u3067A+1\u3068\u3057\u307e\u3059\u30fb\u30fb\u30fb =CODE(A1)+1 \u3053\u308c\u3067\u30b3\u30fc\u30c9\u304c\u51fa\u3066\u307e\u3059\u306e\u3067CHAR\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u6587\u5b57\u306b\u5909\u63db\u3057\u307e\u3059\u30fb\u30fb\u30fb =CHAR(CODE(A1)+1)\u2026","published":"2011-06-05 11:54:05"}