{"id":3054,"date":"2021-10-27T20:30:56","date_gmt":"2021-10-27T11:30:56","guid":{"rendered":"https:\/\/www.bold.ne.jp\/engineer-club\/?p=3054"},"modified":"2025-11-19T10:03:01","modified_gmt":"2025-11-19T01:03:01","slug":"vba-trim","status":"publish","type":"post","link":"https:\/\/www.bold.ne.jp\/engineer-club\/vba-trim","title":{"rendered":"VBA\u306eTrim\u95a2\u6570\u3068\u306f\uff1f\u57fa\u672c\u7684\u306a\u69cb\u6587\u3068\u4f7f\u3044\u65b9\u3092\u89e3\u8aac"},"content":{"rendered":"<p>\u3042\u308b\u6587\u5b57\u5217\u306e\u5148\u982d\u3084\u672b\u5c3e\u306b\u3042\u308b\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3057\u305f\u3044\u3068\u601d\u3063\u305f\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304b\u3002<\/p>\n<p>LTrim\u95a2\u6570\u3001<span>Rtrim<\/span>\u95a2\u6570\u3001<span>Trim<\/span>\u95a2\u6570\u7b49\u3092\u5229\u7528\u3059\u308b\u3068\u3001\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001<span>Trim<\/span>\u95a2\u6570\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">\u76ee\u6b21<\/p><ul class=\"toc_list\"><li><a href=\"#VBATrim\">\uff11\uff0eVBA\u306eTrim\u95a2\u6570\u306b\u3064\u3044\u3066<\/a><ul><li><a href=\"#-Trim\">\uff11-\uff11\uff0eTrim\u95a2\u6570\u3068\u306f<\/a><\/li><li><a href=\"#-Trim-2\">\uff11-\uff12\uff0eTrim\u95a2\u6570\u306e\u69cb\u6587<\/a><\/li><\/ul><\/li><li><a href=\"#VBATrim-2\">\uff12\uff0e\u3010VBA\u3011Trim\u95a2\u6570\u306e\u4f7f\u7528\u4f8b<\/a><ul><li><a href=\"#i\">\uff12-\uff11\uff0e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/a><\/li><li><a href=\"#i-2\">\uff12-\uff12\uff0e\u30b9\u30da\u30fc\u30b9\u4ee5\u5916\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408<\/a><\/li><\/ul><\/li><li><a href=\"#VBALTrimRTrim\">\uff13\uff0e\u3010VBA\u3011LTrim\u95a2\u6570\u3001RTrim\u95a2\u6570\u306b\u3064\u3044\u3066<\/a><\/li><li><a href=\"#i-3\">\uff14\uff0e\u6700\u5f8c\u306b<\/a><\/li><\/ul><\/div>\n<h2><span id=\"VBATrim\">\uff11\uff0eVBA\u306eTrim\u95a2\u6570\u306b\u3064\u3044\u3066<\/span><\/h2>\n<h3><span id=\"-Trim\"><span>\uff11-\uff11\uff0eTrim<\/span>\u95a2\u6570\u3068\u306f<\/span><\/h3>\n<p><span>Trim<\/span>\u95a2\u6570\u3068\u306f\u3001<strong><\/strong><span class=\"f-marker-p\"><strong><span class=\"f-marker-y\">\u6587\u5b57\u5217\u306e\u5148\u982d\u3068\u672b\u5c3e\u306e\u7a7a\u767d\u3092\u524a\u9664\u3059\u308b\u95a2\u6570<\/span><\/strong><\/span>\u3067\u3059\u3002\u300c\u5207\u308a\u843d\u3068\u3059\u300d\u300c\u5208\u308a\u8fbc\u3093\u3067\u304d\u308c\u3044\u306b\u3059\u308b\u300d\u3068\u3044\u3063\u305f\u82f1\u8a9e\u306e\u300c<span>Trim<\/span>\u300d\u304c\u95a2\u6570\u540d\u306e\u5143\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<h3><span id=\"-Trim-2\"><span>\uff11-\uff12\uff0eTrim<\/span>\u95a2\u6570\u306e\u69cb\u6587<\/span><\/h3>\n<div class=\"attention a-1\">\n<p><span>Trim(<\/span>\u6587\u5b57\u5217<span>)<\/span><\/p>\n<p>\u623b\u308a\u5024\u306f\u6587\u5b57\u5217(string)\u5f62\u5f0f<\/p>\n<\/div>\n<p>\u5148\u982d\u3068\u672b\u5c3e\u306e\u4e21\u65b9\u306e\u30b9\u30da\u30fc\u30b9\u3092\u9664\u3044\u305f\u6587\u5b57\u5217\u3092\u8fd4\u3057\u307e\u3059\u3002\u6587\u5b57\u5217\u306b<span>Null<\/span>\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u3001<span>Null<\/span>\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<h2><span id=\"VBATrim-2\">\uff12\uff0e\u3010VBA\u3011<span>Trim<\/span>\u95a2\u6570\u306e\u4f7f\u7528\u4f8b<\/span><\/h2>\n<h3><span id=\"i\">\uff12-\uff11\uff0e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/span><\/h3>\n<p>\u5206\u304b\u308a\u3084\u3059\u3044\u3088\u3046\u306b\u3001\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3092\u300c<span>@<\/span>\u300d\u3001\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u3092\u300c<span>\u25b3<\/span>\u300d\u3067\u8868\u8a18\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"prettyprint lang:default decode:true\">Sub SampleTrim1()\r\n    Dim strH As String\r\n    Dim strF As String\r\n    Dim strA As String\r\n\r\n    strH = \"@@@ABC@@@\"          '\u5148\u982d\u3068\u672b\u5c3e\u306b\u534a\u89d2\u30b9\u30da\u30fc\u30b9\r\n    strF = \"\u25b3\u25b3\u25b3\uff21\uff22\uff23\u25b3\u25b3\u25b3\" '\u5148\u982d\u3068\u672b\u5c3e\u306b\u5168\u89d2\u30b9\u30da\u30fc\u30b9\r\n\r\n    ' \u5b9f\u884c\u524d\u5f8c\u306e\u6587\u5b57\u5217\u3092\u8868\u793a\r\n    strA = Trim(strH)\r\n    MsgBox \"\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u306e\u524a\u9664\" &amp; vbCrLf &amp; _\r\n           \"Trim\u524d\uff1a\u300c\" &amp; strH &amp; \"\u300d\" &amp; vbCrLf &amp; _\r\n           \"Trim\u5f8c\uff1a\u300c\" &amp; strA &amp; \"\u300d\"\r\n\r\n    ' \u5b9f\u884c\u524d\u5f8c\u306e\u6587\u5b57\u5217\u3092\u8868\u793a\r\n    strA = Trim(strF)\r\n    MsgBox \"\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u306e\u524a\u9664\" &amp; vbCrLf &amp; _\r\n           \"Trim\u524d\uff1a\u300c\" &amp; strF &amp; \"\u300d\" &amp; vbCrLf &amp; _\r\n           \"Trim\u5f8c\uff1a\u300c\" &amp; strA &amp; \"\u300d\"\r\nEnd Sub\r\n<\/pre>\n<p><strong><\/strong><span class=\"f-marker-p\"><strong>\u5b9f\u884c\u7d50\u679c\uff1a<\/strong><\/span>\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3001\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u3068\u3082\u306b\u524a\u9664\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2021\/10\/\u7d50\u679c1.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2021\/10\/\u7d50\u679c1.png\" alt=\"\" width=\"137\" height=\"154\" class=\"alignnone size-full wp-image-3055\" \/>\u3000\u3000\u3000\u3000<\/a><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2021\/10\/\u7d50\u679c2.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2021\/10\/\u7d50\u679c2.png\" alt=\"\" width=\"199\" height=\"154\" class=\"alignnone size-full wp-image-3056\" \/><\/a><\/p>\n<p>\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3068\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u304c\u6df7\u5728\u3057\u3066\u3044\u3066\u3082\u3001\u524a\u9664\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"prettyprint lang:default decode:true\">Sub SampleTrim2()\r\n    Dim strHF As String\r\n    Dim strA As String\r\n\r\n    strHF = \"\u25b3@\uff21\uff22\uff23\u25b3@\u25b3\" '\u5148\u982d\u3068\u672b\u5c3e\u306b\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u3068\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u304c\u6df7\u5728\r\n\r\n    strA = Trim(strHF)\r\n    \r\n    ' \u5b9f\u884c\u524d\u5f8c\u306e\u6587\u5b57\u5217\u3092\u8868\u793a\r\n    MsgBox \"\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3001\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u306e\u524a\u9664\" &amp; vbCrLf &amp; _\r\n           \"Trim\u524d\uff1a\u300c\" &amp; strHF &amp; \"\u300d\" &amp; vbCrLf &amp; _\r\n           \"Trim\u5f8c\uff1a\u300c\" &amp; strA &amp; \"\u300d\"\r\n\r\nEnd Sub\r\n<\/pre>\n<p><strong><\/strong><span class=\"f-marker-p\"><strong>\u5b9f\u884c\u7d50\u679c\uff1a<\/strong><\/span>\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3001\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u304c\u6df7\u5728\u3057\u3066\u3044\u3066\u3082\u524a\u9664\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2021\/10\/\u7d50\u679c3.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2021\/10\/\u7d50\u679c3.png\" alt=\"\" width=\"190\" height=\"154\" class=\"alignnone size-full wp-image-3057\" \/><\/a><\/p>\n<p>\u305f\u3060\u3057\u3001\u6587\u5b57\u5217\u306e\u9014\u4e2d\u306b\u3042\u308b\u30b9\u30da\u30fc\u30b9\u306f\u524a\u9664\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<pre class=\"prettyprint lang:default decode:true\">Sub SampleTrim3()\r\n    Dim str As String\r\n    Dim strA As String\r\n\r\n    str = \"@\u25b3\uff21@\uff22\u25b3\uff23\u25b3@\" '\u6587\u5b57\u5217\u306e\u9014\u4e2d\u306b\u5168\u89d2\u30b9\u30da\u30fc\u30b9\u3068\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u304c\u6df7\u5728\r\n\r\n    strA = Trim(str)\r\n    \r\n    ' \u5b9f\u884c\u524d\u5f8c\u306e\u6587\u5b57\u5217\u3092\u8868\u793a\r\n    MsgBox \"\u6587\u5b57\u5217\u306e\u9014\u4e2d\u306b\u30b9\u30da\u30fc\u30b9\u304c\u5b58\u5728\" &amp; vbCrLf &amp; _\r\n           \"Trim\u524d\uff1a\u300c\" &amp; str &amp; \"\u300d\" &amp; vbCrLf &amp; _\r\n           \"Trim\u5f8c\uff1a\u300c\" &amp; strA &amp; \"\u300d\"\r\n\r\nEnd Sub<\/pre>\n<p><strong><\/strong><span class=\"f-marker-p\"><strong>\u5b9f\u884c\u7d50\u679c\uff1a<\/strong><\/span>\u6587\u5b57\u5217\u524d\u5f8c\u306e\u30b9\u30da\u30fc\u30b9\u306f\u524a\u9664\u3055\u308c\u307e\u3059\u304c\u3001\u6587\u5b57\u5217\u5185\u306e\u30b9\u30da\u30fc\u30b9\u306f\u524a\u9664\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2021\/10\/\u7d50\u679c4.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2021\/10\/\u7d50\u679c4.png\" alt=\"\" width=\"181\" height=\"154\" class=\"alignnone size-full wp-image-3058\" \/><\/a><\/p>\n<h3><span id=\"i-2\">\uff12-\uff12\uff0e\u30b9\u30da\u30fc\u30b9\u4ee5\u5916\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408<\/span><\/h3>\n<p>\u30b9\u30da\u30fc\u30b9\u4ee5\u5916\u306e\u6587\u5b57\u3084\u7279\u6b8a\u6587\u5b57\u3092\u524a\u9664\u3057\u305f\u3044\u5834\u5408\u306f\u3001<span>Replace<\/span>\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<h2><span id=\"VBALTrimRTrim\">\uff13\uff0e\u3010VBA\u3011<span>LTrim<\/span>\u95a2\u6570\u3001<span>RTrim<\/span>\u95a2\u6570\u306b\u3064\u3044\u3066<\/span><\/h2>\n<p><span>Trim<\/span>\u95a2\u6570\u3067\u306f\u3001\u6587\u5b57\u5217\u306e\u524d\u5f8c\u306b\u3042\u308b\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3057\u307e\u3059\u304c\u3001\u6587\u5b57\u5217\u306e\u524d\u306e\u307f\u3001\u5f8c\u306e\u307f\u524a\u9664\u3059\u308b\u95a2\u6570\u3082\u5b58\u5728\u3057\u307e\u3059\u3002<\/p>\n<blockquote>\n<p>\u30fb\u6587\u5b57\u5217\u306e\u524d\u306e\u307f\u524a\u9664\u3059\u308b<\/p>\n<p><span>LTrim(&#8220;<\/span>\u6587\u5b57\u5217<span>&#8220;)<\/span><\/p>\n<p>\u30fb\u6587\u5b57\u5217\u306e\u5f8c\u306e\u307f\u524a\u9664\u3059\u308b<\/p>\n<p><span>RTrim(&#8220;<\/span>\u6587\u5b57\u5217<span>&#8220;)<\/span><\/p>\n<\/blockquote>\n<h2><span id=\"i-3\">\uff14\uff0e\u6700\u5f8c\u306b<\/span><\/h2>\n<p>Trim\u95a2\u6570\u3092\u4f7f\u7528\u306e\u5834\u5408\u306f\u3001\u3069\u306e\u4f4d\u7f6e\u306e\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3059\u308b\u304b\u3092\u660e\u78ba\u306b\u3057\u305f\u4e0a\u3067\u3001\u4f7f\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3042\u308b\u6587\u5b57\u5217\u306e\u5148\u982d\u3084\u672b\u5c3e\u306b\u3042\u308b\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3057\u305f\u3044\u3068\u601d\u3063\u305f\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304b\u3002 LTrim\u95a2\u6570\u3001Rtrim\u95a2\u6570\u3001Trim\u95a2\u6570\u7b49\u3092\u5229\u7528\u3059\u308b\u3068\u3001\u30b9\u30da\u30fc\u30b9\u3092\u524a\u9664\u3067\u304d\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001Trim\u95a2\u6570\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002 \u76ee\u6b21\uff11\uff0eVBA [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":3059,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/3054"}],"collection":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/comments?post=3054"}],"version-history":[{"count":5,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/3054\/revisions"}],"predecessor-version":[{"id":6061,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/3054\/revisions\/6061"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media\/3059"}],"wp:attachment":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media?parent=3054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/categories?post=3054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}