{"width":"100%","published":"2025-02-07 16:29:28","blog_url":"https://eigo-gayomenai-engineer.hatenablog.com/","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Feigo-gayomenai-engineer.hatenablog.com%2Fentry%2F2025%2F02%2F07%2F162928\" title=\"Excel\u95a2\u6570\uff1a\u62bd\u51fa\u30fb\u524a\u9664\u30fb\u5224\u5b9a\u30fb\u30a8\u30e9\u30fc\u51e6\u7406\u306e\u5177\u4f53\u4f8b - IT\u306e\u3048\u3093\u3074\u3064\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","provider_name":"Hatena Blog","title":"Excel\u95a2\u6570\uff1a\u62bd\u51fa\u30fb\u524a\u9664\u30fb\u5224\u5b9a\u30fb\u30a8\u30e9\u30fc\u51e6\u7406\u306e\u5177\u4f53\u4f8b","categories":[],"author_url":"https://blog.hatena.ne.jp/eigo-gayomenai-engineer/","blog_title":"IT\u306e\u3048\u3093\u3074\u3064","url":"https://eigo-gayomenai-engineer.hatenablog.com/entry/2025/02/07/162928","type":"rich","version":"1.0","provider_url":"https://hatena.blog","description":"1. \u62bd\u51fa 1.1. LEFT\u95a2\u6570\u00d7FIND\u95a2\u6570\u3067\u7279\u5b9a\u306e\u6587\u5b57\u3088\u308a\u524d\u3092\u62bd\u51fa\u3059\u308b 1.2. RIGHT\u95a2\u6570\u00d7FIND\u95a2\u6570\u3067\u7279\u5b9a\u306e\u6587\u5b57\u4ee5\u964d\u3092\u62bd\u51fa\u3059\u308b 1.3. CHAR(10)\u00d7FIND\u95a2\u6570\u3067\u30bb\u30eb\u5185\u306e\u6539\u884c\u3055\u308c\u305f\u30c6\u30ad\u30b9\u30c8\u304b\u30891\u884c\u76ee\u3060\u3051\u3092\u62bd\u51fa\u3059\u308b 2. \u524a\u9664 2.1. LEFT\u95a2\u6570\u3067\u6587\u5b57\u5217\u306e\u672b\u5c3e\u3092\u524a\u9664\u3059\u308b 2.2. SUBSTITUTE\u95a2\u6570\u3067\u6587\u5b57\u5217\u4e2d\u306e\u6307\u5b9a\u306e\u6587\u5b57\u3092\u524a\u9664\u3059\u308b 2.3. CLEAN\u95a2\u6570\u3067\u4f59\u8a08\u306a\u6539\u884c\u3092\u524a\u9664\u3059\u308b 3. \u5224\u5b9a 3.1. SEARCH\u95a2\u6570\u3067\u7279\u5b9a\u306e\u6587\u5b57\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u304b\u5224\u5b9a\u3059\u308b 4. \u30a8\u30e9\u30fc 4.1.IFERROR\u95a2\u6570\u3067#DIV/0!\u3084#N/A!\u3001#VALUE!\u3092\u8868\u793a\u3055\u305b\u306a\u3044 4.2. \u2026","author_name":"eigo-gayomenai-engineer"}