{"width":"100%","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/y/ycloud/20241225/20241225092902.jpg","description":"Excel\u306e\u300cNUMBERVALUE \u95a2\u6570\u300d\u306f\u30c6\u30ad\u30b9\u30c8\u5f62\u5f0f\u306e\u6570\u5b57\u3092\u6570\u5024\u306b\u5909\u63db\u3067\u304d\u308b\u95a2\u6570\u3067\u3059\u3002\u300cVALUE\u95a2\u6570\u300d\u3084\u65b0\u3057\u3044\u300cREGEXREPLACE\u95a2\u6570\u300d\u3067\u306e\u5909\u63db\u306e\u9055\u3044\u306b\u3064\u3044\u3066\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002OCR\u306a\u3069\u306e\u5229\u7528\u6642\u306b\u8a8d\u8b58\u3057\u305f\u4f59\u5206\u306a\u30b9\u30da\u30fc\u30b9\u524a\u9664\u306b\u3082\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002 \u5185\u5bb9\uff1a NUMBERVALUE \u95a2\u6570\u306b\u3064\u3044\u3066 \u6d3b\u7528\u4f8b\uff08VALUE\u95a2\u6570\u3084REGEXREPLACE\u95a2\u6570\u3068\u306e\u9055\u3044\uff09 \u52d5\u4f5c\u78ba\u8a8d\u306eExcel\u306f\u300cMicrosoft\u00ae Excel\u00ae for Microsoft 365 MSO\u300d\uff08\u30d0\u30fc\u30b8\u30e7\u30f32410\uff09\u3067\u3059\u3002 NUMBERVALUE \u95a2\u6570\u306b\u3064\u3044\u3066 Microsoft \u30b5\u30dd\u30fc\u30c8\u306e\u8aac\u660e\u3067\u306f\u300c\u30ed\u30b1\u30fc\u30eb\u306b\u4f9d\u5b58\u3057\u306a\u3044\u65b9\u6cd5\u3067\u2026","height":"190","published":"2024-12-25 12:30:00","author_name":"ycloud","categories":["Excel"],"url":"https://shikumika.org/entry/excel-numbervalue","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fshikumika.org%2Fentry%2Fexcel-numbervalue\" title=\"\u3010Excel\u3011NUMBERVALUE \u95a2\u6570\u3067\u30c6\u30ad\u30b9\u30c8\u5f62\u5f0f\u306e\u6570\u5b57\u3092\u6570\u5024\u306b\u5909\u63db\u4f8b - 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_title":"shikumika\u2019s diary","provider_name":"Hatena Blog","title":"\u3010Excel\u3011NUMBERVALUE \u95a2\u6570\u3067\u30c6\u30ad\u30b9\u30c8\u5f62\u5f0f\u306e\u6570\u5b57\u3092\u6570\u5024\u306b\u5909\u63db\u4f8b","version":"1.0","author_url":"https://blog.hatena.ne.jp/ycloud/","provider_url":"https://hatena.blog","blog_url":"https://shikumika.org/","type":"rich"}