{"provider_url":"https://hatena.blog","type":"rich","blog_title":"\u3044\u304d\u306a\u308a\u7b54\u3048\u308b\u5099\u5fd8\u9332","description":"Excel\u3067\u3001\u6587\u5b57\u5217\u304c\u6307\u5b9a\u3057\u305f\u6b63\u898f\u8868\u73fe\u306b\u3042\u3066\u306f\u307e\u308b\u304b\uff08\u3042\u3066\u306f\u307e\u308b\u90e8\u5206\u3092\u542b\u3080\u304b\uff09\u5224\u5b9a\u3067\u304d\u308b\u3001REGEXTEST\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u7d39\u4ecb\u3057\u307e\u3059\u3002 REGEXTEST\u95a2\u6570\u306e\u6a5f\u80fd\u3068\u69cb\u6587 \u4f7f\u7528\u3067\u304d\u308b\u6b63\u898f\u8868\u73fe \u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b \u90e8\u5206\u4e00\u81f4\uff08\uff5e\u3092\u542b\u3080\uff09\u5224\u5b9a \u524d\u65b9\u4e00\u81f4\uff08\uff5e\u3067\u59cb\u307e\u308b\uff09\u5224\u5b9a \u5f8c\u65b9\u4e00\u81f4\uff08\uff5e\u3067\u7d42\u308f\u308b\uff09\u5224\u5b9a \u5b8c\u5168\u4e00\u81f4\u5224\u5b9a\u306b\u3059\u308b\u5834\u5408 FILTER\u95a2\u6570\u3067\u306e\u6761\u4ef6\u6307\u5b9a\u306e\u4f8b \u300c\u542b\u307e\u306a\u3044\u300d\u7b49\u306e\u5224\u5b9a\u65b9\u6cd5 \u8907\u6570\u6761\u4ef6\u3067\u5224\u5b9a\u3059\u308b\u65b9\u6cd5 AND\u6761\u4ef6\uff08\u304b\u3064\uff09\u306e\u5834\u5408 OR\u6761\u4ef6\uff08\u307e\u305f\u306f\uff09\u306e\u5834\u5408 \u5099\u8003 REGEXTEST\u95a2\u6570\u306e\u6a5f\u80fd\u3068\u69cb\u6587 REGEXTEST\u95a2\u6570\u306f\u3001\u6587\u5b57\u5217\u304c\u6b63\u898f\u8868\u73fe\u3067\u8868\u3055\u308c\u308b\u30d1\u30bf\u30fc\u30f3\u306b\u3042\u3066\u306f\u307e\u308b\u304b\u3069\u3046\u304b\u3001\u6b63\u78ba\u306b\u306f\u5f53\u3066\u306f\u307e\u308b\uff08\u2026","categories":["Excel"],"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/accs2014/20250926/20250926181258.png","provider_name":"Hatena Blog","url":"https://www.officeisyours.com/entry/2025/09/26/222346","blog_url":"https://www.officeisyours.com/","version":"1.0","author_url":"https://blog.hatena.ne.jp/accs2014/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.officeisyours.com%2Fentry%2F2025%2F09%2F26%2F222346\" title=\"\uff08Excel\uff09REGEXTEST\u95a2\u6570\u306e\u4f7f\u3044\u65b9 - \u3044\u304d\u306a\u308a\u7b54\u3048\u308b\u5099\u5fd8\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"accs2014","published":"2025-09-26 22:23:46","title":"\uff08Excel\uff09REGEXTEST\u95a2\u6570\u306e\u4f7f\u3044\u65b9","width":"100%","height":"190"}