{"id":6930,"date":"2019-04-01T07:00:58","date_gmt":"2019-03-31T22:00:58","guid":{"rendered":"https:\/\/www.jimuya.com\/?p=6930"},"modified":"2019-04-01T06:13:19","modified_gmt":"2019-03-31T21:13:19","slug":"excel%e3%81%a7%e6%97%a5%e4%bb%98%e3%81%8b%e3%82%89%e3%80%8c%e6%9c%88%e7%81%ab%e6%b0%b4%e3%80%8d%e6%9b%9c%e6%97%a5%e3%82%92%e8%a1%a8%e7%a4%ba%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.jimuya.com\/?p=6930","title":{"rendered":"Excel\u3067\u65e5\u4ed8\u304b\u3089\u300c\u6708\u706b\u6c34\u2026\u300d\u66dc\u65e5\u3092\u8868\u793a\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"\n

\u65b0\u5e74\u5ea6\u3068\u3044\u3046\u3053\u3068\u3082\u3042\u308a\u3001<\/p>\n\n\n\n

Excel\u3067\u4f1a\u793e\u306e\u30ab\u30ec\u30f3\u30c0\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3044\u308b<\/p>\n\n\n\n

\u3068\u3044\u3046\u65b9\u3082\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

<\/p>\n\n\n\n

Excel\u3067\u306f\u65e5\u4ed8\u3092\u66dc\u65e5\u306b\u5909\u63db\u3059\u308b\u8a08\u7b97\u5f0f\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u899a\u3048\u3066\u304a\u304f\u3068\u66dc\u65e5\u306e\u5165\u529b\u30df\u30b9\u304c\u7121\u304f\u3066\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n

<\/p>\n\n\n\n

\u66dc\u65e5\u3092\u8868\u793a\u3059\u308btext\u95a2\u6570\u3092\u4f7f\u3046\u65b9\u6cd5<\/h2>\n\n\n\n

text\u95a2\u6570\u306f\u3001\u6307\u5b9a\u3057\u305f\u30bb\u30eb\u306e\u5024\u3092\u6587\u5b57\u5217\u306b\u5909\u63db\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n

\u5f0f\u306e\u57fa\u672c\u306f<\/p>\n\n\n\n

\uff1dtext(\u6307\u5b9a\u30bb\u30eb,\u8868\u793a\u66f8\u5f0f)<\/p>\n\n\n\n

\u3067\u3059\u304c\u3001\u3053\u306e\u300c\u8868\u793a\u66f8\u5f0f\u300d\u6b04\u306e\u6307\u5b9a\u65b9\u6cd5\u3092\u5909\u3048\u308b\u3053\u3068\u3067<\/p>\n\n\n\n

\u66dc\u65e5\u3092\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n

\u305f\u3060\u3057\u66dc\u65e5\u8868\u793a\u306e\u5834\u5408\u306f<\/p>\n\n\n\n

\uff1dtext(\u6307\u5b9a\u30bb\u30eb, “\u8868\u793a\u66f8\u5f0f”) <\/p>\n\n\n\n

\u8868\u793a\u66f8\u5f0f\u3092\u300c”\u300d\u3067\u56f2\u3046\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3054\u6ce8\u610f\u3092\uff01<\/p>\n\n\n\n

\u4ee5\u4e0b\u304c\u8868\u793a\u66f8\u5f0f\u306e\u5165\u529b\u4f8b\u3068\u8868\u793a\u3055\u308c\u308b\u66dc\u65e5\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n
\u8868\u793a\u66f8\u5f0f<\/td>\u8868\u793a\u3055\u308c\u308b\u66dc\u65e5\u4f8b<\/td><\/tr>
aaa<\/td>\u6708\u3001\u706b\u3001\u6c34<\/td><\/tr>
aaaa<\/td>\u6708\u66dc\u65e5\u3001\u706b\u66dc\u65e5\u3001\u6c34\u66dc\u65e5<\/td><\/tr>
ddd<\/td>Mon\u3001Tue\u3001Wed<\/td><\/tr>
dddd<\/td>Monday\u3001Tuesday\u3001Wednesday<\/td><\/tr><\/tbody><\/table>\n\n\n\n

Excel\u306e\u8868\u306b\u305d\u308c\u305e\u308c\u306e\u8868\u793a\u3054\u3068\u306b\u4e26\u3079\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u2191\u3053\u3093\u306a\u611f\u3058\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\u8a08\u7b97\u5f0f\u306e\u4f8b\u3092\u8868\u793a\u3059\u308b\u3068\u3001<\/p>\n\n\n\n

B2\u306e\u300c\u6708\u300d\u3068\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u306e\u8a08\u7b97\u5f0f\u306f<\/p>\n\n\n\n

=TEXT(A2,”aaa”)<\/strong><\/p>\n\n\n\n

\u3067\u3059\u3002<\/p>\n\n\n\n

<\/p>\n\n\n\n

\u7c21\u5358\u306b\u3067\u304d\u308b\u306e\u3067\u662f\u975e\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u65b0\u5e74\u5ea6\u3068\u3044\u3046\u3053\u3068\u3082\u3042\u308a\u3001 Excel\u3067\u4f1a\u793e\u306e\u30ab\u30ec\u30f3\u30c0\u30fc\u3092\u4f5c\u6210\u3057\u3066\u3044\u308b \u3068\u3044\u3046\u65b9\u3082\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u3002 Excel\u3067\u306f\u65e5\u4ed8\u3092\u66dc\u65e5\u306b\u5909\u63db\u3059\u308b\u8a08\u7b97\u5f0f\u304c\u3042\u308a\u307e\u3059\u3002 \u899a\u3048\u3066\u304a\u304f\u3068\u66dc\u65e5\u306e\u5165\u529b\u30df\u30b9\u304c\u7121\u304f\u3066\u4fbf\u5229\u3067\u3059\u3002 \u66dc … <\/p>\n","protected":false},"author":1,"featured_media":6935,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1518],"tags":[77,76,1689,3295,1686],"class_list":["post-6930","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pc_excel","tag-excel","tag-76","tag-1689","tag-3295","tag-1686"],"_links":{"self":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts\/6930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6930"}],"version-history":[{"count":1,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts\/6930\/revisions"}],"predecessor-version":[{"id":6936,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/posts\/6930\/revisions\/6936"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=\/wp\/v2\/media\/6935"}],"wp:attachment":[{"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jimuya.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}