{"published":"2023-05-28 18:00:00","url":"https://shikumika.org/entry/2023/05/28/180000","height":"190","provider_url":"https://hatena.blog","width":"100%","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/y/ycloud/20230528/20230528061038.jpg","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshikumika.org%2Fentry%2F2023%2F05%2F28%2F180000\" title=\"\u3010Power Query\u3011Excel\u306e\u65e5\u4ed8\u6587\u5b57\u5217\u306b\u3042\u308b\u300c\u5143\u5e74\u300d\u3092\u300c1\u5e74\u300d\u306b\u7f6e\u63db - shikumika\u2019s diary\" 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://shikumika.org/","blog_title":"shikumika\u2019s diary","categories":["PowerQuery"],"author_name":"ycloud","type":"rich","description":"Excel\u3067\u65e5\u4ed8\u6587\u5b57\u5217\u306b\u548c\u66a6\u306e\u300c\u5143\u5e74\u300d\u304c\u3042\u308b\u3068\u304d\u3001DATEVALUE\u95a2\u6570\u3067\u306f\u30b7\u30ea\u30a2\u30eb\u5024\u306b\u306f\u5909\u63db\u3067\u304d\u306a\u3044\uff08\u53cd\u5bfe\u306b\u3001\u897f\u66a6\u304b\u3089\u548c\u66a6\u306e\u300c\u5143\u5e74\u300d\u3078\u306e\u8868\u793a\u306f\u53ef\u80fd\u3060\u304c\uff09\u3002 \u305d\u306e\u305f\u3081\u300c\u691c\u7d22\u3068\u7f6e\u63db\u300d\u306e\u6a5f\u80fd\u3067\u201d\u5143\u5e74\u201d\u3092\u201d1\u5e74\u201d\u306b\u4e00\u62ec\u7f6e\u63db\u3092\u3057\u305f\u308a\u3001SUBSTITUTE\u95a2\u6570\u3067\u7f6e\u63db\u3057\u305f\u308a\u3067\u5bfe\u5fdc\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002 \u4f8b\uff1aDATEVALUE\u95a2\u6570\u3068SUBSTITUTE\u95a2\u6570\u306e\u7d44\u307f\u5408\u308f\u305b \uff08\u30bb\u30eb\u306eA2\u306b\u65e5\u4ed8\u6587\u5b57\u5217\u304c\u5165\u3063\u3066\u3044\u308b\u4e8b\u4f8b\uff09 =DATEVALUE(SUBSTITUTE(A2,\"\u5143\u5e74\",\"1\u5e74\")) Power Query\uff08Excel\u306e\u6a19\u6e96\u6a5f\u80fd\uff09\u3082\u540c\u69d8\u306b\u3001\u6b21\u306e\u3068\u304a\u308a\u548c\u66a6\u306e\u300c\u5143\u5e74\u300d\u304c\u3042\u308b\u3068\u3001\u30b7\u30ea\u30a2\u30eb\u5024\u306b\u5909\u63db\u3067\u304d\u306a\u3044\u3088\u3046\u306a\u306e\u3067\u3001\u2026","provider_name":"Hatena Blog","version":"1.0","author_url":"https://blog.hatena.ne.jp/ycloud/","title":"\u3010Power Query\u3011Excel\u306e\u65e5\u4ed8\u6587\u5b57\u5217\u306b\u3042\u308b\u300c\u5143\u5e74\u300d\u3092\u300c1\u5e74\u300d\u306b\u7f6e\u63db"}