{"id":2700,"date":"2020-03-30T10:00:48","date_gmt":"2020-03-30T01:00:48","guid":{"rendered":"https:\/\/iseed.jp\/?p=2700"},"modified":"2025-08-26T17:30:32","modified_gmt":"2025-08-26T08:30:32","slug":"excel-trim","status":"publish","type":"post","link":"https:\/\/iseed.jp\/blog\/excel-trim\/","title":{"rendered":"\u3081\u3061\u3083\u4f5c\u696d\u52b9\u7387\u5316\uff01\u304a\u3059\u3059\u3081Excel\u95a2\u6570\uff1a\u4e0d\u8981\u306a\u7a7a\u767d\u3092\u4e00\u62ec\u524a\u9664\u3059\u308bTRIM"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Excel(\u30a8\u30af\u30bb\u30eb)\u3067\u30c7\u30fc\u30bf\u3092\u7de8\u96c6\u3057\u3066\u3044\u308b\u6642\u3001\u30bb\u30eb\u5185\u306e\u4e0d\u8981\u306a\u30b9\u30da\u30fc\u30b9\u306b\u56f0\u3063\u305f\u3053\u3068\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\uff1f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7279\u306b\u697d\u5929\u5e02\u5834\u306a\u3069\u306eEC\u30b5\u30a4\u30c8\u306eCSV\u30c7\u30fc\u30bf\u306e\u5834\u5408\u3001\u5546\u54c1\u540d\u3084\u8aac\u660e\u6587\u3001\u753b\u50cfURL\u306e\u30bb\u30eb\u306b\u3044\u3089\u306a\u3044\u7a7a\u767d\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u30a8\u30e9\u30fc\u3084\u8868\u793a\u5d29\u308c\u306e\u539f\u56e0\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7f6e\u63db\u3067\u6d88\u3059\u3068\u6d88\u3057\u305f\u304f\u306a\u3044\u7a7a\u767d\u307e\u3067\u6d88\u3048\u3066\u3057\u307e\u3044\u307e\u3059\u3057\u3001\u624b\u3067\u3072\u3068\u3064\u3072\u3068\u3064\u6d88\u3059\u306e\u306f\u5730\u5473\u306b\u5927\u5909\u3067\u3059\u3088\u306d\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4eca\u56de\u306f\u3001\u30bb\u30eb\u306e\u6587\u5b57\u5217\u5185\u306b\u3042\u308b\u524d\u5f8c\uff06\u9023\u7d9a\u3057\u305f\u7a7a\u767d\u3092TRIM\u95a2\u6570\u3092\u7d39\u4ecb\u3057\u307e\u3059\uff01<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u6587\u5b57\u5217\u306e\u524d\u5f8c\u3068\u9023\u7d9a\u3057\u305f\u7a7a\u767d\u3092\u6d88\u305b\u308bTRIM\u95a2\u6570<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">TRIM\u95a2\u6570\u3067\u6d88\u3059\u3053\u3068\u304c\u3067\u304d\u308b\u306e\u306f\u3001\u3053\u3061\u3089\u306e2\u7a2e\u985e\u306e\u7a7a\u767d\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-custom-box-with-style\"><div class=\"is-style-bg border-2 rounded-lg overflow-hidden bg-[#F8F8F8] border-transparent\"><div class=\"!p-5 md:!p-8 !pt-5 md:!pt-6 !m-0 [&amp;&gt;*]:!mb-4 [&amp;&gt;*]:last:!mb-0\">\n<div class=\"wp-block-custom-list-with-style\"><ul class=\"wp-block-list is-style-default flex flex-col gap-[0em] !pl-6\"><li class=\"marker:text-[#B8C4C6] \"><span class=\"!text-[16px]\">\u6587\u5b57\u5217\u306e\u524d\u5f8c\u306b\u3042\u308b\u534a\u89d2\u30b9\u30da\u30fc\u30b9<\/span><\/li><li class=\"marker:text-[#B8C4C6] \"><span class=\"!text-[16px]\">\u9023\u7d9a\u3057\u305f\u534a\u89d2\u30b9\u30da\u30fc\u30b9<\/span><\/li><\/ul><\/div>\n<\/div><\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u6587\u5b57\u5217\u306e\u524d\u5f8c\u306b\u3042\u308b\u534a\u89d2\u30b9\u30da\u30fc\u30b9<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30bb\u30eb\u5185\u306b\u542b\u307e\u308c\u305f\u6587\u5b57\u5217\u306e\u5148\u982d\u304a\u3088\u3073\u4e00\u756a\u5f8c\u308d\u306b\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u304c\u542b\u307e\u308c\u3066\u3044\u305f\u5834\u5408\u3001\u3053\u3061\u3089\u3092\u4e00\u62ec\u3067\u524a\u9664\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-border\"><img decoding=\"async\" width=\"508\" height=\"137\" src=\"https:\/\/iseed.jp\/blog2\/wp-content\/uploads\/2019\/12\/trim1.png\" alt=\"\" class=\"wp-image-2713\" srcset=\"https:\/\/iseed.jp\/blog\/wp-content\/uploads\/2019\/12\/trim1.png 508w, https:\/\/iseed.jp\/blog\/wp-content\/uploads\/2019\/12\/trim1-300x81.png 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306a\u72b6\u614b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u9023\u7d9a\u3057\u305f\u534a\u89d2\u30b9\u30da\u30fc\u30b9<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">TRIM\u95a2\u6570\u306f\u3082\u3046\u3072\u3068\u3064\u30012\u3064\u4ee5\u4e0a\u9023\u7d9a\u3057\u305f\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3092\u5168\u30661\u3064\u306b\u4fee\u6b63\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-border\"><img decoding=\"async\" width=\"508\" height=\"137\" src=\"https:\/\/iseed.jp\/blog2\/wp-content\/uploads\/2019\/12\/trim2.png\" alt=\"\" class=\"wp-image-2712\" srcset=\"https:\/\/iseed.jp\/blog\/wp-content\/uploads\/2019\/12\/trim2.png 508w, https:\/\/iseed.jp\/blog\/wp-content\/uploads\/2019\/12\/trim2-300x81.png 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306a\u72b6\u614b\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">TRIM\u95a2\u6570\u3092\u4f7f\u3046\u3068\u3001\u3053\u308c\u30892\u7a2e\u985e\u306e\u7a7a\u767d\u3092\u4e00\u6c17\u306b\u524a\u9664\uff06\u4fee\u6b63\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u3066\u3057\u307e\u3046\u3093\u3067\u3059\uff01<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">TRIM\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">TRIM\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306f\u4e16\u754c\u4e00\u7c21\u5358\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0d\u8981\u306a\u7a7a\u767d\u3092\u6d88\u3057\u305f\u3044\u30bb\u30eb\u540d\u3092TRIM\u95a2\u6570\u3067\u56f2\u3046\u3060\u3051\u3002\u4ee5\u4e0b\u306fA1\u30bb\u30eb\u5185\u306e\u4e0d\u8981\u306a\u7a7a\u767d\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408\u306e\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-custom-code-with-style\"><div class=\"!p-8 !pt-10 rounded-lg bg-[#282c34] relative overflow-hidden\"><div class=\"\"><pre class=\"!m-0 !p-0\"><code class=\"!m-0 !p-0 !overflow-hidden\">=TRIM(A1)<\/code><\/pre><button class=\"absolute top-0 right-0 !p-4 !bg-transparent !border-0\" data-tippy-content=\"\u30b3\u30d4\u30fc\u3057\u307e\u3057\u305f\"><svg width=\"14px\" height=\"16px\" viewBox=\"0 0 14 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"text-[#98A7AA] hover:text-[#EEF0F0]\"><path d=\"M5.20039 12.8C4.76039 12.8 4.38372 12.6433 4.07039 12.33C3.75706 12.0167 3.60039 11.64 3.60039 11.2V1.6C3.60039 1.16 3.75706 0.783333 4.07039 0.47C4.38372 0.156667 4.76039 0 5.20039 0H12.4004C12.8404 0 13.2171 0.156667 13.5304 0.47C13.8437 0.783333 14.0004 1.16 14.0004 1.6V11.2C14.0004 11.64 13.8437 12.0167 13.5304 12.33C13.2171 12.6433 12.8404 12.8 12.4004 12.8H5.20039ZM2.00039 16C1.56039 16 1.18372 15.8433 0.870391 15.53C0.557057 15.2167 0.400391 14.84 0.400391 14.4V4C0.400391 3.77333 0.477057 3.58333 0.630391 3.43C0.783724 3.27667 0.973724 3.2 1.20039 3.2C1.42706 3.2 1.61706 3.27667 1.77039 3.43C1.92372 3.58333 2.00039 3.77333 2.00039 4V14.4H10.0004C10.2271 14.4 10.4171 14.4767 10.5704 14.63C10.7237 14.7833 10.8004 14.9733 10.8004 15.2C10.8004 15.4267 10.7237 15.6167 10.5704 15.77C10.4171 15.9233 10.2271 16 10.0004 16H2.00039Z\" fill=\"currentColor\"><\/path><\/svg><\/button><\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u3044\u3084\u3059\u3044\u3060\u3051\u3067\u306a\u304f\u30014\u6587\u5b57\u3067\u624b\u6253\u3061\u3057\u3084\u3059\u3044\u540d\u79f0\u306a\u306e\u3082\u3042\u308a\u304c\u305f\u3044\u3067\u3059\u3088\u306d\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u52a0\u5de5\u3059\u308b\u300c\u30c8\u30ea\u30df\u30f3\u30b0\u300d\u306e\u300cTRIM\u300d\u3060\u3068\u899a\u3048\u3066\u3057\u307e\u3044\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">TRIM\u95a2\u6570\u306e\u6ce8\u610f\u70b9<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">TRIM\u95a2\u6570\u304c\u5bfe\u5fdc\u3057\u3066\u3044\u308b\u306e\u306f\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u306e\u307f\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u306f\u9664\u5916\u3055\u308c\u308b\u306e\u3067\u3001\u5168\u89d2\u3082\u524a\u9664\u3057\u305f\u3044\u5834\u5408\u306f\u5148\u306b\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u3092\u534a\u89d2\u306b\u7f6e\u63db\u3057\u3066\u304b\u3089\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u3055\u3044\u3054\u306b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u3044\u304b\u304c\u3067\u3057\u305f\u304b\uff1f<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CSV\u3067\u5546\u54c1\u540d\u306e\u30ad\u30fc\u30ef\u30fc\u30c9\u3084\u5546\u54c1\u753b\u50cfURL\u3092\u524a\u3063\u305f\u308a\u5897\u3084\u3057\u305f\u308a\u3057\u3066\u3044\u308b\u3068\u3001\u3069\u3046\u3057\u3066\u3082\u4e0d\u8981\u306a\u7a7a\u767d\u304c\u6b8b\u3055\u308c\u3066\u3057\u307e\u3044\u3001\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u304b\u3089\u6c17\u3065\u3044\u305f\u308a\u624b\u3067\u3072\u3068\u3064\u3072\u3068\u3064\u4fee\u6b63\u3057\u305f\u308a\u3068\u3001\u5730\u5473\u306b\u30bf\u30a4\u30e0\u30ed\u30b9\u3092\u3057\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306eTRIM\u95a2\u6570\u3092\u899a\u3048\u3066\u304b\u3089\u306f\u3001\u3068\u308a\u3042\u3048\u305a\u6700\u5f8c\u306b\u4f7f\u3046\u3053\u3068\u3067\u30a8\u30e9\u30fc\u3082\u624b\u9593\u3082\u6fc0\u6e1b\u3057\u305f\u306e\u3067\u3001\u305c\u3072\u7686\u3055\u3093\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel(\u30a8\u30af\u30bb\u30eb)\u3067\u30c7\u30fc\u30bf\u3092\u7de8\u96c6\u3057\u3066\u3044\u308b\u6642\u3001\u30bb\u30eb\u5185\u306e\u4e0d\u8981\u306a\u30b9\u30da\u30fc\u30b9\u306b\u56f0\u3063\u305f\u3053\u3068\u306f\u306a\u3044\u3067\u3057\u3087\u3046\u304b\uff1f \u7279\u306b\u697d\u5929\u5e02\u5834\u306a\u3069\u306eEC\u30b5\u30a4\u30c8\u306eCSV\u30c7\u30fc\u30bf\u306e\u5834\u5408\u3001\u5546\u54c1\u540d\u3084\u8aac\u660e\u6587\u3001\u753b\u50cfURL\u306e\u30bb\u30eb\u306b\u3044\u3089\u306a\u3044\u7a7a\u767d\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u30a8\u30e9\u30fc\u3084 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":2710,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","footnotes":""},"categories":[16],"tags":[],"class_list":["post-2700","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-streamlining"],"_links":{"self":[{"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/posts\/2700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/comments?post=2700"}],"version-history":[{"count":1,"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/posts\/2700\/revisions"}],"predecessor-version":[{"id":5683,"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/posts\/2700\/revisions\/5683"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/media\/2710"}],"wp:attachment":[{"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/media?parent=2700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/categories?post=2700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iseed.jp\/blog\/wp-json\/wp\/v2\/tags?post=2700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}