{"id":55198,"date":"2024-02-01T21:35:16","date_gmt":"2024-02-01T12:35:16","guid":{"rendered":"https:\/\/www.excel-no-mori-blog.jp\/?p=55198"},"modified":"2024-04-23T19:37:37","modified_gmt":"2024-04-23T10:37:37","slug":"%ef%bd%83%ef%bd%83","status":"publish","type":"post","link":"https:\/\/www.excel-no-mori-blog.jp\/?p=55198","title":{"rendered":"\u3010Excel\/\u30a8\u30af\u30bb\u30eb\u3011\u8907\u6570\u306e\u6587\u5b57\u3092\u7f6e\u304d\u63db\u3048\u308bSUBSTITUTE\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u7d39\u4ecb"},"content":{"rendered":"\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">Excel(\u30a8\u30af\u30bb\u30eb\uff09\u3067\u6587\u5b57\u3092\u5225\u306e\u6587\u5b57\u306b\u7f6e\u304d\u63db\u3048\u305f\u3044\u6642\u306f\u3001\u300e\u7f6e\u63db\u300f\u6a5f\u80fd\u304c\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305f\u3060\u3001\u7f6e\u63db\u6a5f\u80fd\u3092\u4f7f\u3046\u3068\u3001\u7f6e\u304d\u63db\u3048\u308b\u524d\u306e\u6587\u5b57\u304c\u6d88\u3048\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u3093\u306a\u6642\u306f\u3001\u30a8\u30af\u30bb\u30eb\u306e<span class=\"st-mymarker-s\">SUBSTITUTE\u95a2\u6570<\/span>(\u30b5\u30d6\u30b9\u30c6\u30a3\u30c6\u30e5\u30fc\u30c8)\u3092\u5229\u7528\u3059\u308b\u3068\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001SUBSTITUTE\u95a2\u6570\u3067\u6587\u5b57\u3092\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5\u3068\u3001\u8907\u6570\u306e\u6587\u5b57\u3092\u540c\u6642\u306b\u307e\u3068\u3081\u3066\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u8a18\u4e8b\u306e\u6700\u5f8c\u306b\u306f\u3001\u300e\u7f6e\u63db\u300f\u6a5f\u80fd\u3068SUBSTITUTE\u95a2\u6570\u306e\u9055\u3044\u3001\u305d\u308c\u305e\u308c\u306e\u30e1\u30ea\u30c3\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u3068\u306f\uff1f<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong>SUBSTITUTE\u95a2\u6570<\/strong>\u306e\u8aad\u307f\u65b9\u306f\u3001\u30b5\u30d6\u30b9\u30c6\u30a3\u30c1\u30e5\u30fc\u30c8\u95a2\u6570\u3068\u8aad\u307f\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SUBSTITUTE\u306f\u82f1\u8a9e\u3067\u3001\u65e5\u672c\u8a9e\u3067\u306f\u300e\u4ee3\u308f\u308a\u300f\u300e\u4ee3\u66ff\u300f\u300e\u4ea4\u63db\u300f\u3068\u3044\u3063\u305f\u610f\u5473\u3092\u6301\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u306e\u610f\u5473\u304b\u3089\u3082\u30a4\u30e1\u30fc\u30b8\u3067\u304d\u308b\u3088\u3046\u306b\u3001<strong><span class=\"st-mymarker-s\">SUBSTITUTE\u95a2\u6570<\/span><\/strong>\u3068\u306f\u3001<span class=\"st-mymarker-s\">\u30bb\u30eb\u5185\u306e<strong>\u6587\u5b57\u3092\u5225\u306e\u6587\u5b57\u306b\u7f6e\u304d\u63db\u3048\u308b<\/strong><\/span>\u3053\u3068\u304c\u3067\u304d\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u306e\u69cb\u6587\u3068\u5f15\u6570<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SUBSTITUTE\u95a2\u6570\u306e\u69cb\u6587\u3068\u5f15\u6570\u306f\u3001\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-background\" style=\"background-color:#c8ffc8\"><strong>\uff1dSUBSTITUTE(\u6587\u5b57\u5217,\u691c\u7d22\u6587\u5b57\u5217,\u7f6e\u63db\u6587\u5b57\u5217,[\u7f6e\u63db\u5bfe\u8c61])<\/strong><\/p>\n\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u308c\u305e\u308c\u306e\u5f15\u6570\u306e\u8a73\u7d30\u306f\u3001\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-border has-st-solid-border has-st-thick-border-width has-st-margin-bottom has-st-margin-bottom-2\"><strong>\u7b2c\uff11\u5f15\u6570<\/strong>\u300c<strong><span class=\"st-mymarker-s\">\u6587\u5b57\u5217<\/span><\/strong>\u300d\uff1a<span class=\"dotline\">\u7f6e\u304d\u63db\u3048\u305f\u3044\u6587\u5b57\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb<\/span>\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u30bb\u30eb\u3092\u6307\u5b9a\u305b\u305a\u3001\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u300c\u201d\u300d\u3067\u56f2\u307f\u307e\u3059\u3002\uff08\u4f8b\uff1aA2\u3001B4\uff09<\/p>\n\n\n\n<p class=\"has-st-border has-st-solid-border has-st-thick-border-width has-st-margin-bottom has-st-margin-bottom-2\"><strong>\u7b2c\uff12\u5f15\u6570<\/strong>\u300c<span class=\"st-mymarker-s\">\u691c\u7d22<strong>\u6587\u5b57\u5217<\/strong><\/span>\u300d\uff1a <span class=\"dotline\">\u3069\u306e\u6587\u5b57\u3092\u7f6e\u63db\u3059\u308b\u304b<\/span>\u3001\u30bb\u30eb\u3082\u3057\u304f\u306f\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u30bb\u30eb\u3092\u6307\u5b9a\u305b\u305a\u3001\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u300c\u201d\u300d\u3067\u56f2\u307f\u307e\u3059\u3002\uff08\u4f8b\uff1a\u201dMS\u201d\u3001B4\uff09<\/p>\n\n\n\n<p class=\"has-st-border has-st-solid-border has-st-thick-border-width has-st-margin-bottom has-st-margin-bottom-2\"><strong>\u7b2c\uff13\u5f15\u6570<\/strong>\u300c<span class=\"st-mymarker-s\">\u7f6e\u63db<strong>\u6587\u5b57\u5217<\/strong><\/span>\u300d\uff1a&nbsp;<span class=\"dotline\">\u3069\u306e\u6587\u5b57\u306b\u7f6e\u63db\u3059\u308b\u304b<\/span>\u3001\u30bb\u30eb\u3082\u3057\u304f\u306f\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002\u30bb\u30eb\u3092\u6307\u5b9a\u305b\u305a\u3001\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u300c\u201d\u300d\u3067\u56f2\u307f\u307e\u3059\u3002\uff08\u4f8b\uff1a\u201dON\u201d\u3001C4\uff09<\/p>\n\n\n\n<p class=\"has-st-border has-st-solid-border has-st-thick-border-width has-st-margin-bottom has-st-margin-bottom-2\"><strong>\u7b2c\uff14\u5f15\u6570<\/strong>\u300c<strong><span class=\"st-mymarker-s\">[\u7f6e\u63db\u5bfe\u8c61]<\/span><\/strong>\u300d\uff1a\u7701\u7565\u53ef\u80fd\u3067\u3059\u3002 <span class=\"st-mymarker-s\">\u4f55\u756a\u76ee<\/span>\u306e\u300c\u691c\u7d22\u6587\u5b57\u5217\u300d\u3092\u7f6e\u63db\u3059\u308b\u304b\u3092\u6570\u5b57\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002 \u6570\u5b57\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u6307\u5b9a\u3057\u305f\u9806\u756a\u306e\u6587\u5b57\u5217<span class=\"dotline\">\u3060\u3051<\/span>\u304c\u7f6e\u304d\u63db\u3048\u3089\u308c\u307e\u3059\u3002 \uff08\u4f8b\uff1a\uff11\u3001\uff12\uff09<br><strong><span class=\"dotline\">\u21e9\u6307\u5b9a\u3057\u306a\u3044\u5834\u5408<\/span><\/strong><br>\u691c\u7d22\u6587\u5b57\u5217\u4e2d\u306e<span class=\"st-mymarker-s\">\u3059\u3079\u3066\u306e\u6587\u5b57\u5217\u304c\u7f6e\u63db\u6587\u5b57\u306b\u7f6e\u304d\u63db\u3048<\/span>\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u306e\u4f7f\u3044\u65b9<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001SUBSTITUTE\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u6587\u5b57\u5217\u306b\u542b\u307e\u308c\u308b\u53e5\u8aad\u70b9\u306e\u300e\u3001\u300f\u3092\u3001\u3059\u3079\u3066\u300e\u3002\u300f\u306b\u7f6e\u304d\u63db\u3048\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><strong><span class=\"oomozi\">=SUBSTITUTE(B3,&#8221;<span class=\"st-mymarker-s-b\">\u3001<\/span>&#8220;,&#8221;<span class=\"st-mymarker-s\">\u3002<\/span>&#8220;)<\/span><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-1.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-1.png\" alt=\"\u30a8\u30af\u30bb\u30eb\u306eSUBSTITUTE\u95a2\u6570\u306e\u4f7f\u3044\u65b9(\u3059\u3079\u3066\u7f6e\u63db\uff09\" class=\"wp-image-55239\" width=\"461\" height=\"201\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30a8\u30af\u30bb\u30eb\u306eSUBSTITUTE\u95a2\u6570\u306e\u4f7f\u3044\u65b9(\u3059\u3079\u3066\u7f6e\u63db\uff09<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eee\u306b\u3001\uff12\u3064\u76ee\u306e\u300c\u3001\u300d\u3060\u3051\u3092\u300c\u3002\u300d\u306b\u4fee\u6b63\u3057\u305f\u3044\u5834\u5408\u306f\u3001\uff14\u3064\u76ee\u306e\u5f15\u6570<span class=\"st-mymarker-s\">\u300c<strong><strong>[\u7f6e\u63db\u5bfe\u8c61]<\/strong><\/strong>\u300d\u306b\u201d\uff12\u201d<\/span>\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"oomozi\">=SUBSTITUTE(B3,&#8221;\u3001&#8221;,&#8221;\u3002&#8221;,<span class=\"st-mymarker-s\">2<\/span>)<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-3.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-3.png\" alt=\"\u30a8\u30af\u30bb\u30eb\u306eSUBSTITUTE\u95a2\u6570\u306e\u4f7f\u3044\u65b9(\u4e00\u90e8\u3060\u3051\u3092\u7f6e\u63db)\" class=\"wp-image-55243\" width=\"447\" height=\"195\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30a8\u30af\u30bb\u30eb\u306eSUBSTITUTE\u95a2\u6570\u306e\u4f7f\u3044\u65b9(\u4e00\u90e8\u3060\u3051\u3092\u7f6e\u63db)<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u3067\u6587\u5b57\u3092\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u308c\u3067\u306f\u3001SUBSTITUTE\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3001\u6587\u5b57\u3092\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u5b9f\u4f8b\u3068\u3057\u3066\u3001\u4e0b\u306e\u8868\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u300cDK\u300d\u3092\u3059\u3079\u3066\u300cDR\u300d\u306b\u7f6e\u304d\u63db\u3048\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-4.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-4.png\" alt=\"SUBSTITUTE\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3001\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u7f6e\u304d\u63db\u3048\" class=\"wp-image-55251\" width=\"585\" height=\"259\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3001\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u7f6e\u304d\u63db\u3048<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff11\uff0eSUBSTITUTE\u95a2\u6570\u3092\u633f\u5165<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">D\u5217\u306b\u65b0\u3057\u3044\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u306e\u3067\u3001D3\u30bb\u30eb\u306b<strong>SUBSTITUTE\u95a2\u6570\u3092\u633f\u5165<\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30bb\u30eb\u306b<span class=\"st-mymarker-s\">\u300c<strong>=<\/strong>SU\u300d\u3068\u5165\u529b<\/span>\u3059\u308b\u3068\u3001\u5229\u7528\u3059\u308b\u95a2\u6570\u306e\u5019\u88dc\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u306e\u4e2d\u304b\u3089<span class=\"st-mymarker-s\"><strong>SUBSTITUTE<\/strong>\u95a2\u6570\u3092\u9078\u629e<\/span>\u3057\u3001&nbsp;\u300c<strong>Tab<\/strong>&nbsp;\u300d\u30ad\u30fc\u3092\u62bc\u3057\u307e\u3059\u3002(\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af\u3067\u9078\u629e\u3082\u53ef\uff09<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-5.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-5.png\" alt=\"\u95a2\u6570\u5019\u88dc\u304b\u3089SUBSTITUTE\u95a2\u6570\u3092\u9078\u629e\" class=\"wp-image-55255\" width=\"606\" height=\"325\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u95a2\u6570\u5019\u88dc\u304b\u3089SUBSTITUTE\u95a2\u6570\u3092\u9078\u629e<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u3046\u3059\u308b\u3068\u3001SUBSTITUTE\u95a2\u6570\u3092\u633f\u5165\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><strong><span class=\"oomozi\">=SUBSTITUTE(<\/span><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-6.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-6.png\" alt=\"SUBSTITUTE\u95a2\u6570\u3092\u633f\u5165\" class=\"wp-image-55259\" width=\"598\" height=\"304\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u3092\u633f\u5165<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff12\uff0eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff11\u5f15\u6570\u300c\u6587\u5b57\u5217\u300d\u3092\u6307\u5b9a<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6b21\u306b\u7f6e\u304d\u63db\u3048\u305f\u3044\u6587\u5b57\u5217\u304c\u5165\u3063\u3066\u3044\u308bC3\u30bb\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">C3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u3089\u3001\u6b21\u306e\u5f15\u6570\u3092\u9078\u629e\u3059\u308b\u305f\u3081\u300c<strong>,<\/strong>\u300d(\u30ab\u30f3\u30de)\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"oomozi\">=SUBSTITUTE(<span class=\"st-mymarker-s\">C3,<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-7.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-7.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff11\u5f15\u6570\u300c\u6587\u5b57\u5217\u300d\u3092\u9078\u629e\" class=\"wp-image-55264\" width=\"590\" height=\"262\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff11\u5f15\u6570\u300c\u6587\u5b57\u5217\u300d\u3092\u9078\u629e<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff13\uff0e\u7b2c\uff12\u5f15\u6570\u300c\u691c\u7d22\u6587\u5b57\u5217\u300d\u3092\u6307\u5b9a<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6b21\u306b\u3001<strong>\u7f6e\u304d\u63db\u3048\u305f\u3044\u6587\u5b57\u5217<\/strong>\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eca\u56de\u306f\u300cDK\u300d\u3068\u3044\u3046\u6587\u5b57\u3092\u300cDR\u300d\u3068\u3044\u3046\u6587\u5b57\u306b\u7f6e\u63db\u3057\u305f\u3044\u306e\u3067\u3001\u300cDK\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6587\u5b57\u5217\u306f\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u300c\u201d\u201d\u300d\u3067\u56f2\u3080\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3001\u300c<strong>\u201cDK\u201d<\/strong>\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\u5165\u529b\u3057\u305f\u3089\u3001\u6b21\u306e\u5f15\u6570\u3092\u9078\u629e\u3059\u308b\u305f\u3081\u300c<strong>,<\/strong>\u300d(\u30ab\u30f3\u30de)\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><strong><span class=\"oomozi\">=SUBSTITUTE(C3,<span class=\"st-mymarker-s\">&#8220;DK&#8221;,<\/span><\/span><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-8.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-8.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u7b2c2\u5f15\u6570\u300c\u691c\u7d22\u6587\u5b57\u5217\u300d\u3092\u6307\u5b9a\" class=\"wp-image-55267\" width=\"602\" height=\"275\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u7b2c2\u5f15\u6570\u300c\u691c\u7d22\u6587\u5b57\u5217\u300d\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300cDK\u300d\u3068\u3044\u3046\u6587\u5b57\u306fG3\u30bb\u30eb\u306b\u3082\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001<span class=\"st-mymarker-s\">\u30bb\u30eb\u756a\u53f7\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059<\/span>\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u306e\u969b\u306f\u3001\u4ed6\u306e\u30bb\u30eb\u306b\u3082\u95a2\u6570\u3092\u5229\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u305f\u3081\u306b\u3001\u7d76\u5bfe\u53c2\u7167\u300c$\u300d\u306e\u8a2d\u5b9a\u3092\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=SUBSTITUTE(C3,<span class=\"st-mymarker-s\">$G$3,<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-9.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-9.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u7b2c2\u5f15\u6570\u300c\u691c\u7d22\u6587\u5b57\u5217\u300d\u3092\u30bb\u30eb\u3067\u6307\u5b9a\" class=\"wp-image-55268\" width=\"600\" height=\"263\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u7b2c2\u5f15\u6570\u300c\u691c\u7d22\u6587\u5b57\u5217\u300d\u3092\u30bb\u30eb\u3067\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u7d76\u5bfe\u53c2\u7167\u304c\u5206\u304b\u3089\u306a\u3044\u65b9\u306f\u3001\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-excel\u306e\u68ee wp-block-embed-excel\u306e\u68ee\"><div class=\"wp-block-embed__wrapper\">\n<div><a href=\"https:\/\/www.excel-no-mori-blog.jp\/?p=3095\" class=\"st-cardlink st-embed-cardlink\"><div class=\"kanren st-cardbox\"><dl class=\"clearfix\"><dt class=\"st-card-img\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2022\/03\/excel-absolute-relative-reference-f4-1-1000x530.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/dt><dd><p class=\"st-cardbox-t\">\u3010Excel\/\u30a8\u30af\u30bb\u30eb\u3011\u7d76\u5bfe\u53c2\u7167\u3068\u76f8\u5bfe\u53c2\u7167\u3068\u306f\uff1f\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u300cF4\u300d\u3067\u7c21\u5358\u306b\u5207\u66ff\uff01<\/p><div class=\"st-card-excerpt smanone\"><p>Excel(\u30a8\u30af\u30bb\u30eb\uff09\u3067\u95a2\u6570\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u3068\u300c\u53c2\u7167\u300d\u3068\u3044\u3046\u30ef\u30fc\u30c9\u3092\u826f\u304f\u898b\u304b\u3051\u307e\u3059\u3002 \u3057\u304b\u3057\u300c\u53c2\u7167\u300d\u3068\u3044\u3046\u8a00\u8449\u3092\u3088\u304f\u5206\u304b\u3089 &#8230; <\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff14\uff0eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff13\u5f15\u6570\u300c\u7f6e\u63db\u6587\u5b57\u5217\u300d\u3092\u6307\u5b9a<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6b21\u306b\u3001<strong>\u7f6e\u304d\u63db\u3048\u5f8c<\/strong>\u306e\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eca\u56de\u306f\u300cDK\u300d\u3068\u3044\u3046\u6587\u5b57\u3092\u300cDR\u300d\u3068\u3044\u3046\u6587\u5b57\u306b\u7f6e\u63db\u3057\u305f\u3044\u306e\u3067\u3001\u300cDR\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6587\u5b57\u5217\u306f\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u300c\u201d\u201d\u300d\u3067\u56f2\u3080\u5fc5\u8981\u304c\u3042\u308b\u306e\u3067\u3001\u300c<strong>\u201cDR\u201d<\/strong>\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\u5165\u529b\u3057\u305f\u3089\u3001\u300c<strong>\uff09<\/strong>\u300d(\u62ec\u5f27)\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"oomozi\">=SUBSTITUTE(C3,&#8221;DK&#8221;,<span class=\"st-mymarker-s\">&#8220;DR&#8221;)<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-10.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-10.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u7b2c3\u5f15\u6570\u300c\u7f6e\u63db\u6587\u5b57\u5217\u300d\u3092\u6307\u5b9a\" class=\"wp-image-55272\" width=\"600\" height=\"249\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u7b2c3\u5f15\u6570\u300c\u7f6e\u63db\u6587\u5b57\u5217\u300d\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300cDR\u300d\u3068\u3044\u3046\u6587\u5b57\u306fH3\u30bb\u30eb\u306b\u3082\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001<span class=\"st-mymarker-s\">\u30bb\u30eb\u756a\u53f7\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059<\/span>\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u306e\u969b\u306f\u3001\u4ed6\u306e\u30bb\u30eb\u306b\u3082\u95a2\u6570\u3092\u5229\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u305f\u3081\u306b\u3001\u7d76\u5bfe\u53c2\u7167\u300c$\u300d\u306e\u8a2d\u5b9a\u3092\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=SUBSTITUTE(C3,$G$3,<span class=\"st-mymarker-s\">$H$3)<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-11-3.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-11-3.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u7b2c3\u5f15\u6570\u300c\u7f6e\u63db\u6587\u5b57\u5217\u300d\u3092\u30bb\u30eb\u3067\u6307\u5b9a\" class=\"wp-image-55285\" width=\"620\" height=\"266\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u7b2c3\u5f15\u6570\u300c\u7f6e\u63db\u6587\u5b57\u5217\u300d\u3092\u30bb\u30eb\u3067\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:64px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff15\uff0e\u6587\u5b57\u5217\u306e\u7f6e\u304d\u63db\u3048\u304c\u5b8c\u6210<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300cEnter\u300d\u30ad\u30fc\u3092\u62bc\u3057\u3066\u3001SUBSTITUTE\u95a2\u6570\u3092\u78ba\u5b9a\u3055\u305b\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u3046\u3059\u308b\u3068\u3001\u300cDK\u300d\u304c\u300cDR\u300d\u3068\u3044\u3046\u6587\u5b57\u306b\u7f6e\u304d\u63db\u3048\u3055\u3048\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-12.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-12.png\" alt=\"SUBSTITUTE\u95a2\u6570\u3067\u6587\u5b57\u306e\u7f6e\u304d\u63db\u3048\u304c\u5b8c\u4e86\" class=\"wp-image-55286\" width=\"588\" height=\"242\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u3067\u6587\u5b57\u306e\u7f6e\u304d\u63db\u3048\u304c\u5b8c\u4e86<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:74px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6700\u5f8c\u306b\u3001D3\u30bb\u30eb\u306e\u4e0b\u306e\u30bb\u30eb\u306b\u3082SUBSTITUTE\u95a2\u6570\u3092\u4f7f\u3046\u305f\u3081\u306b\u3001D3\u30bb\u30eb\u306e\u53f3\u4e0b\u89d2\u306b\u3042\u308b<span class=\"st-mymarker-s\">\u5341\u5b57\u30de\u30fc\u30af\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af<\/span>\u3057\u3066\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067SUBSTITUTE\u95a2\u6570\u3092\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-13.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-13.png\" alt=\"\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067SUBSTITUTE\u95a2\u6570\u3092\u30b3\u30d4\u30fc\" class=\"wp-image-55289\" width=\"630\" height=\"278\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067SUBSTITUTE\u95a2\u6570\u3092\u30b3\u30d4\u30fc<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:74px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u3067\u8907\u6570\u306e\u6587\u5b57\u3092\u7f6e\u304d\u63db\u3048\u308b\u65b9\u6cd5<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SUBSTITUTE\u95a2\u6570\u306e\u4e2d\u306b\u3001SUBSTITUTE\u95a2\u6570\u3092\u633f\u5165\u3059\u308b\u3053\u3068\u3067\u3001<span class=\"st-mymarker-s\">\u4e00\u5ea6\u306b\u8907\u6570\u306e\u6587\u5b57\u3092\u7f6e\u304d\u63db\u3048<\/span>\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e0b\u306e\u8868\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u306e\u300cDK\u300d\u3092\u300cDR\u300d\u306b\u3001\u3055\u3089\u306b\u540c\u6642\u306b\u300cF\u300d\u3092\u300cFD\u300d\u306b\u4e00\u5ea6\u306b\u7f6e\u304d\u63db\u3048\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-14-1.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-14-1.png\" alt=\"SUBSTITUTE\u95a2\u6570\u3067\u8907\u6570\u306e\u6587\u5b57\u3092\u4e00\u5ea6\u306b\u7f6e\u304d\u63db\u3048\u3059\u308b\u65b9\u6cd5\" class=\"wp-image-55304\" width=\"564\" height=\"283\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u3067\u8907\u6570\u306e\u6587\u5b57\u3092\u4e00\u5ea6\u306b\u7f6e\u304d\u63db\u3048\u3059\u308b\u65b9\u6cd5<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:74px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff11\uff0eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff11\u5f15\u6570\u306bSUBSTITUTE\u95a2\u6570\u3092\u633f<strong>\u5165<\/strong><\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">D\u5217\u306b\u7f6e\u304d\u63db\u3048\u5f8c\u306e\u5546\u54c1\u30b3\u30fc\u30c9\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u306e\u3067\u3001D3\u30bb\u30eb\u306b<strong>SUBSTITUTE\u95a2\u6570\u3092\u633f\u5165<\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-15.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-15.png\" alt=\"SUBSTITUTE\u95a2\u6570\u3092\u633f\u5165\" class=\"wp-image-55307\" width=\"590\" height=\"310\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u3092\u633f\u5165<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:74px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6b21\u306b\u3001SUBSTITUTE\u95a2\u6570\u306e<span class=\"st-mymarker-s\">\u7b2c\uff11\u5f15\u6570\u306e\u4e2d\u306bSUBSTITUTE\u95a2\u6570\u3092\u633f\u5165<\/span>\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u95a2\u6570\u306e\u4e2d\u306b\u3001\u95a2\u6570\u3092\u633f\u5165\u3059\u308b\u3053\u3068\u3092\u300c<strong>\u5165\u308c\u5b50<\/strong>\u300d\u3082\u3057\u304f\u306f\u300c<strong>\u30cd\u30b9\u30c8<\/strong>\u300d\u3068\u3044\u3044\u307e\u3059\u304c\u3001\u300c\u5165\u308c\u5b50\u300d\u306e\u30c6\u30af\u30cb\u30c3\u30af\u3092\u5229\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\uff12\u3064\u76ee\u306eSUBSTITUTE\u95a2\u6570\u3067\u3001\u300cDK\u300d\u304c\u300cDR\u300d\u306b\u7f6e\u304d\u63db\u3048\u3055\u308c\u308b\u3088\u3046\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u95a2\u6570\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\u5165\u529b\u3057\u305f\u3089\u3001\u6b21\u306e\u5f15\u6570\u3092\u9078\u629e\u3059\u308b\u305f\u3081\u300c<strong>,<\/strong>\u300d(\u30ab\u30f3\u30de)\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><span class=\"oomozi\">=SUBSTITUTE(<span class=\"st-mymarker-s\">SUBSTITUTE(C3,&#8221;DK&#8221;,&#8221;DR&#8221;),<\/span><\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-16.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-16.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u4e2d\u306bSUBSTITUTE\u95a2\u6570\u3092\u633f\u5165(\u5165\u308c\u5b50\u3092\u5229\u7528\uff09\" class=\"wp-image-55311\" width=\"564\" height=\"286\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u4e2d\u306bSUBSTITUTE\u95a2\u6570\u3092\u633f\u5165(\u5165\u308c\u5b50\u3092\u5229\u7528\uff09<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:74px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff12\uff0eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u3092\u6307\u5b9a<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\uff11\u3064\u76ee\u306eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u306b\u3001\u7f6e\u304d\u63db\u3048\u3059\u308b\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300cF\u300d\u3092\u300cFD\u300d\u306b\u7f6e\u304d\u63db\u3048\u3057\u305f\u3044\u306e\u3067\u3001\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u3001<span class=\"st-mymarker-s\">\u201dF\u201d\u3068\u5165\u529b<\/span>\u3057\u307e\u3059\u3002\u5165\u529b\u3057\u305f\u3089\u3001\u6b21\u306e\u5f15\u6570\u3092\u9078\u629e\u3059\u308b\u305f\u3081\u300c<strong>,<\/strong>\u300d(\u30ab\u30f3\u30de)\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-pen has-st-margin-bottom has-st-margin-bottom-2\"><strong><span class=\"oomozi\">=SUBSTITUTE(SUBSTITUTE(C3,&#8221;DK&#8221;,&#8221;DR&#8221;),<span class=\"st-mymarker-s\">&#8220;F&#8221;,<\/span><\/span><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-17.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-17.png\" alt=\"\uff11\u3064\u76ee\u306eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u3092\u8a2d\u5b9a\" class=\"wp-image-55315\" width=\"566\" height=\"284\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\uff11\u3064\u76ee\u306eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u3092\u8a2d\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:69px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff13\uff0eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff13\u5f15\u6570\u3092\u6307\u5b9a<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\uff11\u3064\u76ee\u306eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff13\u5f15\u6570\u306b\u3001<span class=\"dotline\">\u7f6e\u304d\u63db\u3048\u5f8c\u306e\u6587\u5b57\u5217<\/span>\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300cF\u300d\u3092\u300cFD\u300d\u306b\u7f6e\u304d\u63db\u3048\u3057\u305f\u3044\u306e\u3067\u3001\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u3001<span class=\"st-mymarker-s\">\u201dFD\u201d\u3068\u5165\u529b<\/span>\u3057\u307e\u3059\u3002\u5165\u529b\u3057\u305f\u3089\u3001SUBSTITUTE\u95a2\u6570\u3092\u9589\u3058\u308b\u305f\u3081\u300c<strong>\uff09<\/strong>\u300d(\u30ab\u30c3\u30b3)\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><strong>=SUBSTITUTE(SUBSTITUTE(C3,&#8221;DK&#8221;,&#8221;DR&#8221;),&#8221;F&#8221;,<span class=\"st-mymarker-s\">&#8220;FD&#8221;)<\/span><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-18.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-18.png\" alt=\"\uff11\u3064\u76ee\u306eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff13\u5f15\u6570\u3092\u8a2d\u5b9a\" class=\"wp-image-55320\" width=\"655\" height=\"325\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\uff11\u3064\u76ee\u306eSUBSTITUTE\u95a2\u6570\u306e\u7b2c\uff13\u5f15\u6570\u3092\u8a2d\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:69px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u624b\u9806\uff14\uff0eSUBSTITUTE\u95a2\u6570\u3092\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067\u30b3\u30d4\u30fc<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300cEnter\u300d\u30ad\u30fc\u3092\u62bc\u3057\u3066\u3001SUBSTITUTE\u95a2\u6570\u3092\u78ba\u5b9a\u3055\u305b\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6700\u5f8c\u306b\u3001D3\u30bb\u30eb\u306e\u4e0b\u306e\u30bb\u30eb\u306b\u3082SUBSTITUTE\u95a2\u6570\u3092\u4f7f\u3046\u305f\u3081\u306b\u3001D3\u30bb\u30eb\u306e\u53f3\u4e0b\u89d2\u306b\u3042\u308b<span class=\"st-mymarker-s\">\u5341\u5b57\u30de\u30fc\u30af\u3092\u30c0\u30d6\u30eb\u30af\u30ea\u30c3\u30af<\/span>\u3057\u3066\u3001\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3067SUBSTITUTE\u95a2\u6570\u3092\u30b3\u30d4\u30fc\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-19.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-19.png\" alt=\"SUBSTITUTE\u95a2\u6570\u3092\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3063\u3066\u30b3\u30d4\u30da\" class=\"wp-image-55322\" width=\"651\" height=\"323\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u3092\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3092\u4f7f\u3063\u3066\u30b3\u30d4\u30da<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:69px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u3046\u3059\u308b\u3068\u3001\u300cDK\u300d\u3092\u300cDR\u300d\u306b\u3001\u300cF\u300d\u3092\u300cFD\u300d\u306b\u3001\uff12\u3064\u306e\u6587\u5b57\u5217\u3092\u540c\u6642\u306b\u7f6e\u304d\u63db\u3048\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-20.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-20.png\" alt=\"SUBSTITUTE\u95a2\u6570\u3067\u8907\u6570\u306e\u6587\u5b57\u3092\u540c\u6642\u306b\u7f6e\u304d\u63db\u3048\u304c\u5b8c\u4e86\" class=\"wp-image-55325\" width=\"645\" height=\"366\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u3067\u8907\u6570\u306e\u6587\u5b57\u3092\u540c\u6642\u306b\u7f6e\u304d\u63db\u3048\u304c\u5b8c\u4e86<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e0a\u306e\u4f8b\u3067\u306f\u3001SUBSTITUTE\u95a2\u6570\u306e\u5f15\u6570\u306f\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u201d\u201d\u3092\u5229\u7528\u3057\u3066\u6587\u5b57\u5217\u3092\u6307\u5b9a\u3057\u307e\u3057\u305f\u304c\u3001\u4e0b\u306e\u3088\u3046\u306b\u3001\u30bb\u30eb\u3092\u6307\u5b9a\u3057\u3066\u4f5c\u6210\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><strong>=SUBSTITUTE(SUBSTITUTE(C3,$G$3,$H$3),$G$4,$H$4)<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-21.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-21.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u5f15\u6570\u306b\u30bb\u30eb\u756a\u53f7\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\" class=\"wp-image-55329\" width=\"649\" height=\"318\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u5f15\u6570\u306b\u30bb\u30eb\u756a\u53f7\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u3068\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u3068\u306e\u9055\u3044\u3092\u7d39\u4ecb<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SUBSTITUTE\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u7d39\u4ecb\u3057\u3066\u304d\u307e\u3057\u305f\u304c\u3001\u30a8\u30af\u30bb\u30eb\u306e<span class=\"st-mymarker-s\">\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u3068\u4f55\u304c\u9055\u3046<\/span>\u306e\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6587\u5b57\u3092\u7f6e\u304d\u63db\u3048\u308b\u3068\u3044\u3046\u610f\u5473\u3067\u6a5f\u80fd\u306f\u540c\u3058\u3088\u3046\u306b\u601d\u3048\u307e\u3059\u304c\u3001SUBSTITUTE\u95a2\u6570\u3001\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u3001<span class=\"st-mymarker-s\">\u305d\u308c\u305e\u308c\u306e\u826f\u3055<\/span>\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u6700\u5f8c\u306b\u3001SUBSTITUTE\u95a2\u6570\u3068\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u306e\u9055\u3044\u3092\u7d39\u4ecb\u3057\u307e\u3059\u306e\u3067\u3001\u3069\u3046\u3044\u3063\u305f\u30b1\u30fc\u30b9\u306b\u5229\u7528\u3059\u308c\u3070\u4fbf\u5229\u306a\u306e\u304b\u3092\u5224\u65ad\u3059\u308b\u6750\u6599\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u306f\u3001\u7f6e\u63db\u524d\u306e\u30c7\u30fc\u30bf\u304c\u6b8b\u308b<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SUBSTITUTE\u95a2\u6570\u306f\u3001\u7f6e\u63db\u3057\u305f\u3044\u6587\u5b57\u3092\u6307\u5b9a\u3057\u3066\u3001\u305d\u306e\u7d50\u679c\u3092\u5225\u306e\u30bb\u30eb\u306b\u8868\u793a\u3059\u308b\u306e\u3067\u3001<span class=\"st-mymarker-s\">\u7f6e\u63db\u524d\u306e\u30c7\u30fc\u30bf\u304c\u6b8b\u308a\u307e\u3059<\/span>\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e00\u65b9\u3001\u7f6e\u63db\u6a5f\u80fd\u306f\u3001\u7f6e\u63db\u304c\u884c\u308f\u308c\u308b\u3068\u3001\u7f6e\u63db\u524d\u306e\u30c7\u30fc\u30bf\u306f\u6b8b\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u7f6e\u63db\u524d\u306e\u8a18\u9332\u3092\u6b8b\u3057\u3066\u304a\u304d\u305f\u3044\u3001\u3082\u3057\u304f\u306f\u7f6e\u63db\u3059\u308b\u6587\u5b57\u3092\u5909\u66f4\u3057\u305f\u3044\u5834\u5408\u306f\u3001SUBSTITUTE\u95a2\u6570\u304c\u304a\u5968\u3081\u3067\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-22.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-22.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u30e1\u30ea\u30c3\u30c8\uff1a\u7f6e\u63db\u524d\u306e\u30c7\u30fc\u30bf\u304c\u6b8b\u308b\" class=\"wp-image-55330\" width=\"603\" height=\"334\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u30e1\u30ea\u30c3\u30c8\uff1a\u7f6e\u63db\u524d\u306e\u30c7\u30fc\u30bf\u304c\u6b8b\u308b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u306f\u3001\u6570\u5f0f\u306e\u7f6e\u63db\u304c\u53ef\u80fd<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u3067\u306f\u3001\u6587\u5b57\u5217\u3060\u3051\u3067\u306a\u304f<span class=\"st-mymarker-s\">\u6570\u5f0f\u3082\u7f6e\u63db<\/span>\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4f8b\u3048\u3070\u3001\u4e0b\u306e\u8868\u306e\u3088\u3046\u306b\u3001\uff17\u884c\u76ee\u306eSUM\u95a2\u6570\u304c\u300e=SUM(E3:<span class=\"st-mymarker-s-b\">E5<\/span>)\u300f\u3068\u306a\u3063\u3066\u3044\u3066\u3001<span class=\"st-mymarker-s-b\">\uff16\u884c\u76ee\u306e\u6570\u5024\u304c\u5408\u8a08\u3055\u308c\u3066\u3044\u307e\u305b\u3093<\/span>\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-23.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-23.png\" alt=\"\u7f6e\u63db\u6a5f\u80fd\u306f\u6570\u5f0f\u5185\u306e\u6570\u5b57\u3084\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u306e\u7f6e\u63db\u304c\u53ef\u80fd\" class=\"wp-image-55331\" width=\"471\" height=\"294\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7f6e\u63db\u6a5f\u80fd\u306f\u6570\u5f0f\u5185\u306e\u6570\u5b57\u3084\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u306e\u7f6e\u63db\u304c\u53ef\u80fd<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306e\u3088\u3046\u306b\u3001\u8907\u6570\u306e\u30bb\u30eb\u306eSUM\u95a2\u6570\u306e\u30bb\u30eb\u7bc4\u56f2\u304c\u8aa4\u3063\u3066\u3044\u308b\u5834\u5408\u306b\u306f\u3001\u7f6e\u63db\u6a5f\u80fd\u3092\u5229\u7528\u3059\u308b\u3068\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SUM\u95a2\u6570\u304c\u633f\u5165\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u7bc4\u56f2\u3092\u9078\u629e\u3057\u3066\u304b\u3089\u3001\u7f6e\u63db\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u3001<span class=\"st-mymarker-s\">\u691c\u7d22\u3059\u308b\u6587\u5b57\u5217\u3092\u300c5\u300d<\/span>\u3001<span class=\"st-mymarker-s\">\u7f6e\u63db\u5f8c\u306e\u6587\u5b57\u5217\u3092\u300c6\u300d<\/span>\u3068\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-24.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-24.png\" alt=\"\u7f6e\u63db\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u3001SUM\u95a2\u6570\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u4fee\u6b63\" class=\"wp-image-55332\" width=\"481\" height=\"276\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7f6e\u63db\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u3001SUM\u95a2\u6570\u306e\u30bb\u30eb\u7bc4\u56f2\u3092\u4fee\u6b63<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305d\u3046\u3059\u308b\u3068\u3001\uff17\u884c\u76ee\u306eSUM\u95a2\u6570\u306e\u6570\u5f0f\u3092\u3059\u3079\u3066\u4fee\u6b63\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-25.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-25.png\" alt=\"\u7f6e\u63db\u6a5f\u80fd\u306b\u3088\u3063\u3066\u3001SUM\u95a2\u6570\u306e\u6570\u5f0f\u306e\u4fee\u6b63\u304c\u4e00\u5ea6\" class=\"wp-image-55333\" width=\"461\" height=\"309\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7f6e\u63db\u6a5f\u80fd\u306b\u3088\u3063\u3066\u3001SUM\u95a2\u6570\u306e\u6570\u5f0f\u306e\u4fee\u6b63\u304c\u4e00\u5ea6<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div class=\"wp-block-st-blocks-my-box st-mybox has-title\" style=\"background-color:#fff;border-color:#757575\"><p class=\"st-mybox-title\" style=\"color:#424242;font-weight:bold;text-shadow:#fff 3px 0px 0px, #fff 2.83487px .981584px 0px, #fff 2.35766px 1.85511px 0px, #fff 1.62091px 2.52441px 0px, #fff .705713px 2.91581px 0px, #fff -0.287171px 2.98622px 0px, #fff -1.24844px 2.72789px 0px, #fff -2.07227px 2.16926px 0px, #fff -2.66798px 1.37182px 0px, #fff -2.96998px .42336px 0px, #fff -2.94502px -0.571704px 0px, #fff -2.59586px -1.50383px 0px, #fff -1.96093px -2.27041px 0px, #fff -1.11013px -2.78704px 0px, #fff -0.137119px -2.99686px 0px, #fff .850987px -2.87677px 0px, #fff 1.74541px -2.43999px 0px, #fff 2.44769px -1.73459px 0px, #fff 2.88051px -0.838246px 0px;background:linear-gradient(0deg, #fff 0%, #fff 55%, rgba(0, 0, 0, 0) 55%, rgba(0, 0, 0, 0) 100%)\"><i class=\"st-fa st-svg-check-circle st-css-no\" aria-hidden=\"\"><\/i>\u4fee\u6b63\u3055\u308c\u305f\u6570\u5f0f<\/p><div class=\"st-in-mybox\">\n<p>\u300e=SUM(C3:C5)\u300f\u21d2\u300e=SUM(C3:<span class=\"st-mymarker-s\">C6<\/span>)\u300f<\/p>\n\n\n\n<p>\u300e=SUM(D3:D5)\u300f\u21d2\u300e=SUM(D3:<span class=\"st-mymarker-s\">D6<\/span>)\u300f<\/p>\n\n\n\n<p>\u300e=SUM(E3:E5)\u300f\u21d2\u300e=SUM(E3:<span class=\"st-mymarker-s\">E6<\/span>)\u300f<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u306f\u3001\u4e00\u5ea6\u306b\u8907\u6570\u306e\u7f6e\u63db\u304c\u53ef\u80fd<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eca\u56de\u7d39\u4ecb\u3057\u305f\u3088\u3046\u306b\u3001<span class=\"st-mymarker-s\">SUBSTITUTE\u95a2\u6570\u306f\u8907\u6570\u306e\u6587\u5b57\u3092\u540c\u6642\u306b\u7f6e\u304d\u63db\u3048<\/span>\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e00\u65b9\u3001\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u3067\u3042\u308c\u3070\u3001\u7f6e\u63db\u4f5c\u696d\u3092\u8907\u6570\u56de\u5b9f\u884c\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-26.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-substitute-function-multiple-letter-replace-26.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u30e1\u30ea\u30c3\u30c8\uff1a\u4e00\u5ea6\u306b\u6587\u5b57\u306e\u7f6e\u63db\u304c\u53ef\u80fd\" class=\"wp-image-55342\" width=\"534\" height=\"296\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u30e1\u30ea\u30c3\u30c8\uff1a\u4e00\u5ea6\u306b\u6587\u5b57\u306e\u7f6e\u63db\u304c\u53ef\u80fd<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SUBSTITUTE\u95a2\u6570\u306f\u3001\u4f55\u756a\u76ee\u306e\u6587\u5b57\u3092\u7f6e\u63db\u3059\u308b\u304b\u6307\u5b9a\u3067\u304d\u308b<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">SUBSTITUTE\u95a2\u6570\u306e\u5834\u5408\u3001\u7b2c\uff14\u5f15\u6570\u300c[\u7f6e\u63db\u5bfe\u8c61]\u300d\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001<span class=\"st-mymarker-s\">\u4e00\u90e8\u306e\u6587\u5b57\u3060\u3051\u3092\u7f6e\u63db<\/span>\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4f8b\u3048\u3070\u3001\u4e0b\u306e\u3088\u3046\u306bSUBSTITUTE\u95a2\u6570\u3092\u633f\u5165\u3059\u308b\u3053\u3068\u3067\u3001\u6587\u5b57\u5217\u306e\u4e2d\u306e\uff12\u756a\u76ee\u306e\u300c-\u300d\u3092\u524a\u9664(\u6587\u5b57\u306a\u3057\u306b\u7f6e\u63db)\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2 is-style-st-paragraph-pen\"><span class=\"oomozi\">=SUBSTITUTE(C3,&#8221;-&#8220;,&#8221;&#8221;,<span class=\"st-mymarker-s\">2<\/span>)<\/span><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/02\/excel-substitute-function-multiple-letter-replace-27.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/02\/excel-substitute-function-multiple-letter-replace-27.png\" alt=\"SUBSTITUTE\u95a2\u6570\u306e\u30e1\u30ea\u30c3\u30c8\uff1a\u4e00\u90e8\u306e\u307f\u7f6e\u63db\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\" class=\"wp-image-55346\" width=\"452\" height=\"323\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>SUBSTITUTE\u95a2\u6570\u306e\u30e1\u30ea\u30c3\u30c8\uff1a\u4e00\u90e8\u306e\u307f\u7f6e\u63db\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:72px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u306f\u3001\u5927\u6587\u5b57\u3001\u5c0f\u6587\u5b57\u3001\u534a\u89d2\u3001\u5168\u89d2\u3092\u533a\u5225\u3067\u304d\u308b<\/h3>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u7f6e\u63db\u300d\u6a5f\u80fd\u306f\u3001\u5927\u6587\u5b57\u3001\u5c0f\u6587\u5b57\u3001\u534a\u89d2\u3001\u5168\u89d2\u306e<span class=\"st-mymarker-s\">\u533a\u5225\u3059\u308b\/\u3057\u306a\u3044\u3092\u9078\u629e<\/span>\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4f8b\u3048\u3070\u3001\u5927\u6587\u5b57\u300cA\u300d\u3092\u300cB\u300d\u306b\u7f6e\u63db\u3057\u305f\u3044\u304c\u3001\u5c0f\u6587\u5b57\u300ca\u300d\u3092\u300cB\u300d\u306b\u7f6e\u63db\u3057\u305f\u304f\u306a\u3044\u3001\u3068\u3044\u3063\u305f\u9078\u629e\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4e00\u65b9\u3001SUBSTITUTE\u95a2\u6570\u306b\u533a\u5225\u3059\u308b\/\u3057\u306a\u3044\u3092\u9078\u629e\u3059\u308b\u3053\u3068\u306f\u51fa\u6765\u307e\u305b\u3093\u3002<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/02\/excel-substitute-function-multiple-letter-replace-28.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/02\/excel-substitute-function-multiple-letter-replace-28.png\" alt=\"\u7f6e\u63db\u6a5f\u80fd\u306e\u30e1\u30ea\u30c3\u30c8\uff1a\u5927\u6587\u5b57\u3001\u5c0f\u6587\u5b57\u3001\u534a\u89d2\u3001\u5168\u89d2\u306e\u533a\u5225\u304c\u53ef\u80fd\" class=\"wp-image-55349\" width=\"528\" height=\"262\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7f6e\u63db\u6a5f\u80fd\u306e\u30e1\u30ea\u30c3\u30c8\uff1a\u5927\u6587\u5b57\u3001\u5c0f\u6587\u5b57\u3001\u534a\u89d2\u3001\u5168\u89d2\u306e\u533a\u5225\u304c\u53ef\u80fd<\/strong><\/figcaption><\/figure><\/div>","protected":false},"excerpt":{"rendered":"<p>Excel(\u30a8\u30af\u30bb\u30eb\uff09\u3067\u6587\u5b57\u3092\u5225\u306e\u6587\u5b57\u306b\u7f6e\u304d\u63db\u3048\u305f\u3044\u6642\u306f\u3001\u300e\u7f6e\u63db\u300f\u6a5f\u80fd\u304c\u4fbf\u5229\u3067\u3059\u3002 \u305f\u3060\u3001\u7f6e\u63db\u6a5f\u80fd\u3092\u4f7f\u3046\u3068\u3001\u7f6e\u304d\u63db\u3048\u308b\u524d &#8230;<\/p>\n","protected":false},"author":1,"featured_media":55352,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,24],"tags":[],"class_list":["post-55198","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-24"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/55198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=55198"}],"version-history":[{"count":0,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/55198\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/media\/55352"}],"wp:attachment":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=55198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=55198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=55198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}