{"type":"rich","published":"2006-10-10 00:00:00","title":"Excel \u5f0f\u3067\u30b7\u30fc\u30c8\u306e\u540d\u524d\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5","author_name":"shikaku","author_url":"https://blog.hatena.ne.jp/shikaku/","height":"190","url":"https://blog.systemjp.net/entry/20061010/p1","categories":["EXCEL"],"version":"1.0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.systemjp.net%2Fentry%2F20061010%2Fp1\" title=\"Excel \u5f0f\u3067\u30b7\u30fc\u30c8\u306e\u540d\u524d\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5 - shikaku&#39;s blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://blog.systemjp.net/","description":"\u30b3\u30d4\u30da\u5143 http://question.excite.co.jp/kotaeru.php3?q=2439393 =cell(\"filename\",\u30bb\u30eb) \u3067\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u304c\u3042\u308b\u30b7\u30fc\u30c8\u306e\u30d1\u30b9\u540d\u304c\u5f97\u3089\u308c\u307e\u3059\u3002 \uff08Z:\\[schedule.xls]Sheet2 \u306e\u3088\u3046\u306a\u5177\u5408\u306b\uff09 \u305d\u3053\u304b\u3089\u30b7\u30fc\u30c8\u540d\u3060\u3051\u3092\u53d6\u308a\u51fa\u3059\u306a\u3089 =RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))) \u3067\u3057\u3087\u3046\u304b","provider_url":"https://hatena.blog","width":"100%","blog_title":"shikaku's blog","image_url":null,"provider_name":"Hatena Blog"}