{"id":5643,"date":"2012-11-02T18:10:36","date_gmt":"2012-11-02T09:10:36","guid":{"rendered":"http:\/\/arison.jp\/blog\/?p=5643"},"modified":"2017-06-01T20:30:05","modified_gmt":"2017-06-01T11:30:05","slug":"excel-word-count","status":"publish","type":"post","link":"https:\/\/arison.jp\/blog\/2012\/11\/02\/excel-word-count\/","title":{"rendered":"\u3010Excel\u3011\u30bb\u30eb\u306e\u5358\u8a9e\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b"},"content":{"rendered":"<p>Excel\u306e\u30bb\u30eb\u306e\u5358\u8a9e\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u65b9\u6cd5<\/p>\n<p><a href=\"http:\/\/office.microsoft.com\/ja-jp\/excel-help\/HA010102339.aspx\" title=\"Excel\u306e\u30bb\u30eb\u306e\u5358\u8a9e\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\">Excel\u306e\u30bb\u30eb\u306e\u5358\u8a9e\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b<\/a><\/p>\n<p>=IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,&#8221; &#8220;,&#8221;&#8221;))+1)<br \/>\nA1 \u306b\u542b\u307e\u308c\u308b\u5358\u8a9e\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u306e\u30bb\u30eb\u306e\u5358\u8a9e\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u65b9\u6cd5 Excel\u306e\u30bb\u30eb\u306e\u5358\u8a9e\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b =IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,&#8221; &#038;#8220 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":23768,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,4],"tags":[117],"class_list":["post-5643","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-work","category-diary","tag-excel"],"_links":{"self":[{"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/posts\/5643","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/comments?post=5643"}],"version-history":[{"count":0,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/posts\/5643\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/media\/23768"}],"wp:attachment":[{"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/media?parent=5643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/categories?post=5643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arison.jp\/blog\/wp-json\/wp\/v2\/tags?post=5643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}