{"id":22904,"date":"2022-11-06T12:54:37","date_gmt":"2022-11-06T03:54:37","guid":{"rendered":"https:\/\/www.excel-no-mori-blog.jp\/?p=22904"},"modified":"2024-04-21T20:28:11","modified_gmt":"2024-04-21T11:28:11","slug":"%e3%80%90%e3%82%a8%e3%82%af%e3%82%bb%e3%83%ab%e3%80%91%e3%82%b9%e3%83%9a%e3%83%bc%e3%82%b9%e3%81%8c%e3%81%aa%e3%81%84%e6%b0%8f%e5%90%8d%e3%82%92%e3%80%8e%e5%a7%93%e3%80%8f%e3%81%a8%e3%80%8e%e5%90%8d","status":"publish","type":"post","link":"https:\/\/www.excel-no-mori-blog.jp\/?p=22904","title":{"rendered":"\u3010\u30a8\u30af\u30bb\u30eb\u3011\u30b9\u30da\u30fc\u30b9\u304c\u306a\u3044\u6c0f\u540d\u3092\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306b\u5206\u3051\u308b\u65b9\u6cd5\u3002WEB\u306e\u540d\u5b57\u30ea\u30b9\u30c8\u3092\u6d3b\u7528"},"content":{"rendered":"\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">Excel(\u30a8\u30af\u30bb\u30eb)\u3067\u30b9\u30da\u30fc\u30b9\u304c\u3042\u308b\u6c0f\u540d\u30ea\u30b9\u30c8\u3092\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306b\u5206\u3051\u308b\u65b9\u6cd5\u3092\u3010<a href=\"https:\/\/www.excel-no-mori-blog.jp\/?p=22785\" title=\"\">\u3010\u30a8\u30af\u30bb\u30eb\u3011\u6c0f\u540d\u306e\u300e\u59d3\u300f\u3068\u300e\u540d\u300f(\u300e\u82d7\u5b57\u300f\u3068\u300e\u540d\u524d\u300f)\u3092\u81ea\u52d5\u3067\u5206\u3051\u308b\uff13\u3064\u306e\u65b9\u6cd5<\/a>\u3011\u306e\u8a18\u4e8b\u3067\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3057\u304b\u3057\u3001\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306e\u9593\u306b\u30b9\u30da\u30fc\u30b9\u306a\u3069\u306e<span class=\"st-mymarker-s-b\">\u533a\u5207\u308a\u6587\u5b57\u304c\u7121\u3044\u5834\u5408\u306f\u5206\u5272\u3059\u308b\u306e\u304c\u56f0\u96e3<\/span>\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u4ef6\u6570\u304c\u5c11\u306a\u3051\u308c\u3070\u76ee\u8996\u3067\u5206\u5272\u3057\u305f\u65b9\u304c\u901f\u3044\u3067\u3059\u304c\u3001\u30c7\u30fc\u30bf\u91cf\u304c\u81a8\u5927\u306a\u5834\u5408\u306f\u3001\u4eca\u56de\u7d39\u4ecb\u3059\u308b\u65b9\u6cd5\u3092\u53c2\u8003\u306b\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u4eca\u56de\u306f\u3001\u4e0b\u306e\u8868\u306e\u3088\u3046\u306b\u3001<strong>\u30b9\u30da\u30fc\u30b9\u304c\u306a\u3044\u6c0f\u540d\u3092\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306b\u5206\u3051\u308b\u65b9\u6cd5<\/strong>\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-divide-first-last-name-no-space-2.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-2.png\" alt=\"\u30b9\u30da\u30fc\u30b9\u304c\u306a\u3044\u6c0f\u540d\u3092\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306b\u5206\u3051\u308b\" class=\"wp-image-51166\" width=\"314\" height=\"343\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30b9\u30da\u30fc\u30b9\u304c\u306a\u3044\u6c0f\u540d\u3092\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306b\u5206\u3051\u308b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:45px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u5206\u89e3\u3059\u308b\u5168\u4f53\u306e\u51e6\u7406\u306e\u6d41\u308c<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u30b9\u30da\u30fc\u30b9\u304c\u306a\u3044\u6c0f\u540d\u3092\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306b\u5206\u3051\u308b\u624b\u9806\u306b\u3064\u3044\u3066\u3001<strong>\u5168\u4f53\u306e\u4f5c\u696d\u306e\u6d41\u308c<\/strong>\u3092\u307e\u305a\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u51e6\u7406\u306f\u5927\u304d\u304f\u5206\u3051\u3066\u3001\u4ee5\u4e0b\u306e5\u30b9\u30c6\u30c3\u30d7\u306b\u5206\u304b\u308c\u307e\u3059\u3002\u5404\u898b\u51fa\u3057\u3067\u624b\u9806\u3092\u7d39\u4ecb\u3057\u3066\u307e\u3059\u306e\u3067\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"is-style-st-paragraph-marumozi\"><strong>\u4eca\u56de\u306e\u51e6\u7406\u624b\u9806<\/strong><\/p>\n\n\n\n<ul class=\"is-style-st-no-border has-st-border has-st-solid-border has-st-thick-border-width wp-block-list\">\n<li>WEB\u304b\u3089\u300e<strong>\u65e5\u672c\u4eba\u306e\u540d\u5b57\u30ea\u30b9\u30c8<\/strong>\u300f\u3092\u53d6\u5f97<\/li>\n\n\n\n<li>\u6c0f\u540d\u30ea\u30b9\u30c8\u3092\u6587\u5b57\u6570\u5225\u306b\u5206\u89e3<\/li>\n\n\n\n<li>\u624b\u9806\uff11\u306e\u30ea\u30b9\u30c8\u3092\u4f7f\u3063\u3066\u3001\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u300e\u59d3\u300f\u306e\u5019\u88dc\u3092\u62bd\u51fa<\/li>\n\n\n\n<li>\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u300e\u59d3\u300f\u3092\u7279\u5b9a<\/li>\n\n\n\n<li>\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u300e\u540d\u300f\u3092\u7279\u5b9a<\/li>\n<\/ul>\n\n\n\n<div style=\"height:54px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">WEB\u304b\u3089\u300e<strong>\u65e5\u672c\u4eba\u306e\u540d\u5b57\u30ea\u30b9\u30c8<\/strong>\u300f\u3092\u53d6\u5f97<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306e\u9593\u306b\u30b9\u30da\u30fc\u30b9\u304c\u7121\u3044\u306e\u3067\u3001\u540d\u5b57\u30ea\u30b9\u30c8\u3092\u4f7f\u3063\u3066\u300e\u59d3\u300f\u3092\u7279\u5b9a\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3057\u304b\u3057\u3001\u6b8b\u5ff5\u306a\u304c\u3089\u30a8\u30af\u30bb\u30eb\u306b\u306f\u65e5\u672c\u4eba\u306e<span class=\"st-mymarker-s-b\">\u540d\u5b57\u30ea\u30b9\u30c8\u306f\u767b\u9332\u3055\u308c\u3066\u3044\u307e\u305b\u3093<\/span>\u3002<\/p>\n\n\n\n<p>\u305d\u306e\u305f\u3081\u3001<strong>WEB(\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8)\u304b\u3089\u540d\u5b57\u30ea\u30b9\u30c8\u3092\u53d6\u5f97<\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:39px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff11\uff0e\u300cWEB\u300d\u3092\u958b\u304f<\/span><\/strong><br>\u3010\u540d\u5b57\u7531\u6765net\u3011\u306e\u4ee5\u4e0b\u306eWEB\u306eURL\u3092\u958b\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"is-style-st-paragraph-link has-original-color-c-background-color has-background\"><strong>\u5f15\u7528\u5143\uff1a\u540d\u5b57\u7531\u6765net<\/strong><br><a href=\"https:\/\/www.post.japanpost.jp\/zipcode\/download.html\">https:\/\/www.post.japanpost.jp\/zipcode\/download.html<\/a><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-3.png\"><img decoding=\"async\" width=\"1240\" height=\"327\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-3.png\" alt=\"\u3010\u540d\u5b57\u7531\u6765net\u3011\u306eWEB\u30b5\u30a4\u30c8\" class=\"wp-image-51167\" srcset=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-3.png 1240w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-3-1000x264.png 1000w, https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-3-768x203.png 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/a><figcaption class=\"wp-element-caption\"><strong>\u3010\u540d\u5b57\u7531\u6765net\u3011\u306eWEB\u30b5\u30a4\u30c8<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff12\uff0e\u300c\u5168\u56fd\u30fb\u90fd\u9053\u5e9c\u770c\u5225\u30e9\u30f3\u30ad\u30f3\u30b0\u300d\u3092\u958b\u304f<\/span><\/strong><br>\u300c\u540d\u5b57\u30e9\u30f3\u30ad\u30f3\u30b0\u300d\u21d2\u300c<strong>\u5168\u56fd\u30fb\u90fd\u9053\u5e9c\u770c\u5225\u30e9\u30f3\u30ad\u30f3\u30b0<\/strong>\u300d\u3092\u958b\u304d\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-divide-first-last-name-no-space-4.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-4.png\" alt=\"\u300c\u5168\u56fd\u30fb\u90fd\u9053\u5e9c\u770c\u5225\u30e9\u30f3\u30ad\u30f3\u30b0\u300d\u3092\u958b\u304f\" class=\"wp-image-51169\" width=\"366\" height=\"248\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300c\u5168\u56fd\u30fb\u90fd\u9053\u5e9c\u770c\u5225\u30e9\u30f3\u30ad\u30f3\u30b0\u300d\u3092\u958b\u304f<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:54px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><span style=\"text-decoration: underline\" class=\"underline\"><strong>\u624b\u9806\uff13\uff0e\u300c\uff11\uff5e\uff12\uff10\u4f4d\u306e\u540d\u5b57\u30ea\u30b9\u30c8\u300d\u3092\u30b3\u30d4\u30fc<\/strong><\/span><br>\u300c\uff11\uff5e\uff12\uff10\u4f4d\u306e\u540d\u5b57\u30ea\u30b9\u30c8\u300d\u3092\u9078\u629e\u3057\u3066\u3001\u300cCtrl\uff0bC\u300d\u3067\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-divide-first-last-name-no-space-5.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-5.png\" alt=\"WEB\u30b5\u30a4\u30c8\u306e\u300c\u540d\u5b57\u30ea\u30b9\u30c8\u300d\u3092\u30b3\u30d4\u30fc\" class=\"wp-image-51170\" width=\"290\" height=\"489\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>WEB\u30b5\u30a4\u30c8\u306e\u300c\u540d\u5b57\u30ea\u30b9\u30c8\u300d\u3092\u30b3\u30d4\u30fc<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><span style=\"text-decoration: underline\" class=\"underline\"><strong>\u624b\u9806\uff14\uff0e\u30a8\u30af\u30bb\u30eb\u306b\u8cbc\u308a\u4ed8\u3051<\/strong><\/span><br>Excel\u306e\u5229\u7528\u3057\u3066\u3044\u306a\u3044\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u300cCtrl\uff0bV\u300d\u306e\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3067\u8cbc\u308a\u4ed8\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u8cbc\u308a\u4ed8\u3051\u305f\u5f8c\u306b\u3001\u753b\u9762\u53f3\u4e0b\u306e\u300e<strong>\u8cbc\u308a\u4ed8\u3051\u306e\u30aa\u30d7\u30b7\u30e7\u30f3<\/strong>\u300f\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u300e<strong>\u8cbc\u308a\u4ed8\u3051\u5148\u306e\u66f8\u5f0f\u306b\u5408\u308f\u305b\u308b<\/strong>\u300f\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304f\u3060\u3055\u3044\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-divide-first-last-name-no-space-6.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-6.png\" alt=\"\u300e\u8cbc\u308a\u4ed8\u3051\u5148\u306e\u66f8\u5f0f\u306b\u5408\u308f\u305b\u308b\u300f\u3092\u30af\u30ea\u30c3\u30af\" class=\"wp-image-51171\" width=\"424\" height=\"419\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300e\u8cbc\u308a\u4ed8\u3051\u5148\u306e\u66f8\u5f0f\u306b\u5408\u308f\u305b\u308b\u300f\u3092\u30af\u30ea\u30c3\u30af<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:51px\" 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\u7f6b\u7dda\u3084\u30ea\u30f3\u30af\u306a\u3069\u306e\u8cbc\u308a\u4ed8\u3051\u304c\u6d88\u3048\u3066\u3001\u300e\u6a19\u6e96\u300f\u3067\u8cbc\u308a\u4ed8\u3051\u308b\u3053\u3068\u304c\u51fa\u6765\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-divide-first-last-name-no-space-7.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-7.png\" alt=\"\u30bb\u30eb\u306e\u8868\u793a\u5f62\u5f0f\u3092\u300e\u6a19\u6e96\u300f\u3067\u8cbc\u308a\u4ed8\u3051\" class=\"wp-image-51172\" width=\"262\" height=\"415\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300e\u6a19\u6e96\u300f\u3067\u8cbc\u308a\u4ed8\u3051<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:55px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><span style=\"text-decoration: underline\" class=\"underline\"><strong>\u624b\u9806\uff15\uff0e\uff12\uff11\u4f4d\u4ee5\u4e0b\u306e\u540d\u5b57\u30e9\u30f3\u30ad\u30f3\u30b0\u3082\u8cbc\u308a\u4ed8\u3051<\/strong><\/span><br>\u624b\u9806\uff13\u3001\uff14\u306e\u4f5c\u696d\u3092\u7e70\u308a\u8fd4\u3057\u3066\u3001\u540d\u5b57\u30e9\u30f3\u30ad\u30f3\u30b0\uff12\uff11\u4f4d\u4ee5\u4e0b\u306e\u30e9\u30f3\u30ad\u30f3\u30b0\u3082Excel\u306b\u8cbc\u308a\u4ed8\u3051\u307e\u3059\u3002\u4eca\u56de\u306f\u3001\uff11\uff10\uff10\uff10\u4f4d\u4ee5\u4e0b\u307e\u3067\u306e\u540d\u5b57\u3092\u30a8\u30af\u30bb\u30eb\u306b\u8cbc\u308a\u4ed8\u3051\u3057\u307e\u3059\u3002\u5206\u89e3\u3057\u305f\u3044\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u4eba\u6570\u306b\u5408\u308f\u305b\u3066\u8cbc\u308a\u4ed8\u3051\u308b\u30ea\u30b9\u30c8\u6570\u3092\u5897\u3084\u3057\u3066\u304f\u3060\u3055\u3044\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-divide-first-last-name-no-space-8.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-8.png\" alt=\"\u300e\u82d7\u5b57\u30e9\u30f3\u30ad\u30f3\u30b01,000\u4f4d\u300f\u307e\u3067\u306e\u30e9\u30f3\u30ad\u30f3\u30b0\u3092\u30a8\u30af\u30bb\u30eb\u306b\u8cbc\u308a\u4ed8\u3051\" class=\"wp-image-51173\" width=\"584\" height=\"309\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300e\u82d7\u5b57\u30e9\u30f3\u30ad\u30f3\u30b01,000\u4f4d\u300f\u307e\u3067\u306e\u30e9\u30f3\u30ad\u30f3\u30b0\u3092\u30a8\u30af\u30bb\u30eb\u306b\u8cbc\u308a\u4ed8\u3051<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:54px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u6c0f\u540d\u30ea\u30b9\u30c8\u3092\u6587\u5b57\u6570\u5225\u306b\u5206\u89e3<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u7d9a\u3044\u3066\u3001\u6c0f\u540d\u30ea\u30b9\u30c8\u304b\u3089<strong>\u300e\u59d3\u300f\u306e\u5019\u88dc\u3092\u898b\u3064\u3051\u308b<\/strong>\u305f\u3081\u306b\u30a8\u30af\u30bb\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u52a0\u5de5\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:34px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff11\uff0e\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u6a2a\u306b\u6700\u5927\u6587\u5b57\u6570\u5206\u306e\u5217\u3092\u8ffd\u52a0<\/span><\/strong><br>\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u53f3\u6a2a\u306b\u6c0f\u540d\u306e\u6700\u5927\u6587\u5b57\u6570\u5206\u306e\u5217\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u4e0b\u306e\u8868\u3067\u306f\u3001\u300e\u5c0f\u91ce\u7530\u548c\u4e5f\u300f\u306e\uff15\u6587\u5b57\u304c\u6700\u5927\u6587\u5b57\u6570\u306a\u306e\u3067\u3001\uff15\u884c\u3092\u8ffd\u52a0\u3057\u3001\u5217\u30bf\u30a4\u30c8\u30eb\u306f\u300e5\u300f\u300e4\u300f\u30fb\u30fb\u30fb\u300e\uff11\u300f\u3068\u6570\u5024\u3092\u5165\u529b\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-divide-first-last-name-no-space-9.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-9.jpg\" alt=\"\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u53f3\u6a2a\u306b\u5217\u3092\u8ffd\u52a0\" class=\"wp-image-51174\" width=\"516\" height=\"263\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u53f3\u6a2a\u306b\u5217\u3092\u8ffd\u52a0<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:62px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff12\uff0eLEFT\u95a2\u6570\u3092\u633f\u5165<\/span><\/strong><br>\u4e00\u756a\u4e0a\u306e\u6c0f\u540d\u306e\u6a2a\u306e\u30bb\u30eb\u306b\u4ee5\u4e0b\u306eLEFT\u95a2\u6570\u3092\u633f\u5165\u3057\u3001\u6c0f\u540d\u306e\u5148\u982d\u304b\u3089\u201d\u5217\u30bf\u30a4\u30c8\u30eb\u306e\u6570\u5024\u5206\u306e\u6587\u5b57\u6570\u201d\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002\u3053\u306e\u95a2\u6570\u3092\u5225\u306e\u30bb\u30eb\u306b\u3082\u30b3\u30d4\u30da\u3067\u304d\u308b\u3088\u3046\u306b\u3001\u4ee5\u4e0b\u306e\u4f4d\u7f6e\u306b<strong>\u7d76\u5bfe\u53c2\u7167\u306e\u201d\uff04\u201d\u3092\u633f\u5165<\/strong>\u3057\u3066\u304f\u3060\u3055\u3044\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\">=LEFT(<span class=\"hutoaka\">$<\/span>B3,C<span class=\"hutoaka\">$<\/span>2)<\/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-divide-first-last-name-no-space-10.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-10.jpg\" alt=\"\u6c0f\u540d\u30ea\u30b9\u30c8\u306bLEFT\u95a2\u6570\u3092\u633f\u5165\" class=\"wp-image-51175\" width=\"536\" height=\"310\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u6c0f\u540d\u30ea\u30b9\u30c8\u306bLEFT\u95a2\u6570\u3092\u633f\u5165<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:44px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u5c71\u7530\u592a\u90ce\u300d\u306f\uff14\u6587\u5b57\u306a\u306e\u3067\u3001\uff15\u6587\u5b57\u306e\u629c\u304d\u53d6\u308a\u3092LEFT\u95a2\u6570\u3067\u6307\u5b9a\u3057\u307e\u3057\u305f\u304c\uff14\u6587\u5b57\u304c\u629c\u304d\u53d6\u3089\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-divide-first-last-name-no-space-11.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-11.jpg\" alt=\"\u6c0f\u540d\u306e\u5148\u982d\u304b\u3089\u6587\u5b57\u3092\u62bd\u51fa\" class=\"wp-image-51176\" width=\"552\" height=\"290\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u6c0f\u540d\u306e\u5148\u982d\u304b\u3089\u6587\u5b57\u3092\u62bd\u51fa<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:45px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff13\uff0eLEFT\u95a2\u6570\u3092\u30b3\u30d4\u30da<\/span><\/strong><br>\u624b\u9806\uff12\u3067\u4f5c\u6210\u3057\u305fLEFT\u95a2\u6570\u3092\u305d\u308c\u4ee5\u5916\u306e\u30bb\u30eb\u306b\u3082\u30b3\u30d4\u30da\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-divide-first-last-name-no-space-12.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-12.png\" alt=\"LEFT\u95a2\u6570\u3092\u30b3\u30d4\u30da\" class=\"wp-image-51177\" width=\"574\" height=\"294\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>LEFT\u95a2\u6570\u3092\u30b3\u30d4\u30da<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:49px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">WEB\u30ea\u30b9\u30c8\u3092\u4f7f\u3063\u3066\u3001\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u300e\u59d3\u300f\u306e\u5019\u88dc\u3092\u62bd\u51fa<\/h2>\n\n\n\n<p>LEFT\u95a2\u6570\u3067\u5148\u982d\u306e\u6587\u5b57\u3092\u629c\u304d\u53d6\u3063\u305f\u30ea\u30b9\u30c8\u3068\u3001WEB\u304b\u3089\u53d6\u5f97\u3057\u305f\u540d\u5b57\u30ea\u30b9\u30c8\u304c\u4e00\u81f4\u3057\u305f\u30bb\u30eb\u304c\u300e\u59d3\u300f\u306e\u53ef\u80fd\u6027\u304c\u9ad8\u3044\u3068\u3044\u3046\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u4e00\u81f4\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306bVLOOKUP\u95a2\u6570\u3092\u4f7f\u3063\u3066<strong>\u300c\u59d3\u300d\u306e\u5019\u88dc\u30bb\u30eb<\/strong>\u3092\u898b\u3064\u3051\u307e\u3059\u3002<\/p>\n\n\n\n<div style=\"height:49px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff11\uff0e\u53f3\u6a2a\u306bVLOOKUP\u95a2\u6570\u3092\u633f\u5165<\/span><\/strong><br>\u300e\u59d3\u300f\u306e\u30bb\u30eb\u3092\u898b\u3064\u3051\u308b\u305f\u3081\u306b\u3001\u53f3\u306e\u7a7a\u3044\u305f\u30bb\u30eb\u306b<strong><span class=\"st-mymarker-s\">VLOOKUP\u95a2\u6570\u3092\u633f\u5165<\/span><\/strong>\u3057\u307e\u3059\u3002\u7b2c\uff11\u5f15\u6570\u300c\u691c\u7d22\u5024\u300d\u306f\u3001LEFT\u95a2\u6570\u306e\u633f\u5165\u30bb\u30eb\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span class=\"oomozi\">=VLOOKUP(<span style=\"color:#271fbb\" class=\"tadv-color\">C3<\/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-divide-first-last-name-no-space-13.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-13.jpg\" alt=\"\u540d\u5b57\u30ea\u30b9\u30c8\u3068\u7a81\u304d\u5408\u308f\u305b\u308b\u305f\u3081VLOOKUP\u95a2\u6570\u3092\u633f\u5165\" class=\"wp-image-51178\" width=\"566\" height=\"252\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u540d\u5b57\u30ea\u30b9\u30c8\u3068\u7a81\u304d\u5408\u308f\u305b\u308b\u305f\u3081VLOOKUP\u95a2\u6570\u3092\u633f\u5165<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:53px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff12\uff0e\u7b2c\uff12\u5f15\u6570\u300c\u691c\u7d22\u7bc4\u56f2\u300d\u3092\u6307\u5b9a<\/span><\/strong><br>\u7d9a\u3044\u3066VLOOKUP\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u300c\u691c\u7d22\u7bc4\u56f2\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u307e\u305a\u3001WEB\u306e\u540d\u5b57\u30ea\u30b9\u30c8\u3092\u8cbc\u308a\u4ed8\u3051\u305f\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u304b\u3089\u3001\u540d\u5b57\u5217\u306e\u5217\u756a\u53f7\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066F4\u30ad\u30fc\u3092\u62bc\u3057\u3066\u7d76\u5bfe\u53c2\u7167\u201d\uff04\u201d\u3092\u4ed8\u4e0e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span class=\"oomozi\">=VLOOKUP(C3,<span style=\"color:#1f31b9\" class=\"tadv-color\">WEB\u540d\u5b57\u30e9\u30f3\u30ad\u30f3\u30b0!$B:$B<\/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-divide-first-last-name-no-space-14.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-14.png\" alt=\"VLOOKUP\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u300c\u691c\u7d22\u7bc4\u56f2\u300d\u306b\u540d\u5b57\u30ea\u30b9\u30c8\u3092\u6307\u5b9a\" class=\"wp-image-51179\" width=\"486\" height=\"422\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>VLOOKUP\u95a2\u6570\u306e\u7b2c\uff12\u5f15\u6570\u300c\u691c\u7d22\u7bc4\u56f2\u300d\u306b\u540d\u5b57\u30ea\u30b9\u30c8\u3092\u6307\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:53px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff13\uff0e\u7b2c\uff13\u5f15\u6570\u300c\u5217\u756a\u53f7\u300d\u3068\u7b2c\uff14\u5f15\u6570\u300c\u691c\u7d22\u65b9\u6cd5\u300d\u3092\u6307\u5b9a<\/span><\/strong><br>\u7d9a\u3044\u3066VLOOKUP\u95a2\u6570\u306e\u7b2c\uff13\u5f15\u6570\u300c\u5217\u756a\u53f7\u300d\u3068\u7b2c\uff14\u5f15\u6570\u300c\u691c\u7d22\u65b9\u6cd5\u300d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u5217\u756a\u53f7\u306f\u300c<strong>\uff11<\/strong>\u300d\u3001\u691c\u7d22\u65b9\u6cd5\u306f\u300c<strong>FALSE<\/strong>\u300d\u3092\u4f7f\u3063\u3066\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bVLOOKUP\u95a2\u6570\u3092\u5b8c\u6210\u3055\u305b\u3066ENTER\u3092\u62bc\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><strong><span class=\"oomozi\">=VLOOKUP(C3,WEB\u540d\u5b57\u30e9\u30f3\u30ad\u30f3\u30b0!$B:$B,<span style=\"color:#1f33b6\" class=\"tadv-color\">1,FALSE<\/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-divide-first-last-name-no-space-15.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-15.jpg\" alt=\"VLOOKUP\u95a2\u6570\u3092\u5b8c\u6210\u3055\u305b\u308b\" class=\"wp-image-51181\" width=\"620\" height=\"157\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>VLOOKUP\u95a2\u6570\u3092\u5b8c\u6210\u3055\u305b\u308b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff14\uff0eVLOOKUP\u95a2\u6570\u3092\u30b3\u30d4\u30da<\/span><\/strong><br>LEFT\u95a2\u6570\u3067\u5148\u982d\u306e\u6587\u5b57\u3092\u629c\u304d\u53d6\u3063\u305f\u30ea\u30b9\u30c8\u3068\u3001WEB\u304b\u3089\u53d6\u5f97\u3057\u305f\u540d\u5b57\u30ea\u30b9\u30c8\u304c\u4e00\u81f4\u3057\u305f\u30bb\u30eb\u304c\u4e00\u81f4\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001VLOOKUP\u95a2\u6570\u306e\u7d50\u679c\u306f\u30a8\u30e9\u30fc\u5024\u300e#N\/A\u300f\u304c\u8868\u793a\u3055\u308c\u3001\u4e00\u81f4\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u300c\u59d3\u300d\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u3053\u306eVLOOKUP\u95a2\u6570\u3092\u30b3\u30d4\u30da\u3057\u3066\u3001\u305d\u308c\u4ee5\u5916\u306e\u30bb\u30eb\u3082\u4e00\u81f4\u3059\u308b\u304b\u78ba\u8a8d\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-divide-first-last-name-no-space-16.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-16.png\" alt=\"VLOOKUP\u95a2\u6570\u3092\u4ed6\u306e\u30bb\u30eb\u306b\u3082\u30b3\u30d4\u30da\" class=\"wp-image-51183\" width=\"628\" height=\"288\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>VLOOKUP\u95a2\u6570\u3092\u4ed6\u306e\u30bb\u30eb\u306b\u3082\u30b3\u30d4\u30da<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:52px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff15\uff0eVLOOKUP\u95a2\u6570\u306e\u30bb\u30eb\u3092\u5024\u8cbc\u308a\u4ed8\u3051<\/span><\/strong><br>VLOOKUP\u95a2\u6570\u306f\u3082\u3046\u4f7f\u3044\u307e\u305b\u3093\u306e\u3067\u3001\u5024\u306b\u5909\u63db\u3057\u307e\u3059\u3002VLOOKUP\u95a2\u6570\u3092\u633f\u5165\u3057\u305f\u30bb\u30eb\u3092\u9078\u629e\u3057\u3066\u30b3\u30d4\u30fc\u3057\u3066\u304b\u3089\u3001\u53f3\u30af\u30ea\u30c3\u30af\u30e1\u30cb\u30e5\u30fc\u306e\u300c\u5024\u8cbc\u308a\u4ed8\u3051\u300d\u3067\u5024\u3067\u8cbc\u308a\u4ed8\u3051\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-divide-first-last-name-no-space-17.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-17.png\" alt=\"VLOOKUP\u95a2\u6570\u304c\u633f\u5165\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u3092\u5024\u3067\u8cbc\u308a\u4ed8\u3051\" class=\"wp-image-51184\" width=\"574\" height=\"232\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>VLOOKUP\u95a2\u6570\u304c\u633f\u5165\u3055\u308c\u3066\u3044\u308b\u30bb\u30eb\u3092\u5024\u3067\u8cbc\u308a\u4ed8\u3051<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:44px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff16\uff0e\u300e#N\/A\u300f\u3092\u7a7a\u767d\u306b\u7f6e\u63db<\/span><\/strong><br>\u30a8\u30e9\u30fc\u5024<strong>\u300e#N\/A\u300f<\/strong>\u306e\u30bb\u30eb\u306f\u4e0d\u8981\u306a\u306e\u3067\u3001\u7f6e\u63db\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u524a\u9664\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u307e\u305a\u5024\u8cbc\u308a\u4ed8\u3051\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u3092\u9078\u629e\u3057\u3066\u304b\u3089\u3001\u300cCtrl\u300d\u30ad\u30fc\u3092\u62bc\u3057\u306a\u304c\u3089\u300cH\u300d\u30ad\u30fc\u3092\u62bc\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-divide-first-last-name-no-space-18.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-18.jpg\" alt=\"\u7f6e\u63db\u6a5f\u80fd\u3092\u8868\u793a\u3059\u308b\" class=\"wp-image-51185\" width=\"366\" height=\"266\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u7f6e\u63db\u6a5f\u80fd\u3092\u8868\u793a\u3059\u308b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u300c\u691c\u7d22\u3068\u7f6e\u63db\u300d\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u300c\u691c\u7d22\u3059\u308b\u6587\u5b57\u5217\u300d\u6b04\u306b\u300c#N\/A\u300d\u3092\u5165\u529b\u3057\u3001\u300c\u7f6e\u63db\u5f8c\u306e\u6587\u5b57\u5217\u300d\u306f\u4f55\u3082\u5165\u529b\u3057\u306a\u3044\u307e\u307e\u300c\u3059\u3079\u3066\u7f6e\u63db\u300d\u3092\u30af\u30ea\u30c3\u30af\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-divide-first-last-name-no-space-19.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-19.jpg\" alt=\"\u30a8\u30e9\u30fc\u5024\u300e#N\/A\u300f\u3092\u300c(\u7a7a\u767d)\u300d\u306b\u7f6e\u63db\" class=\"wp-image-51186\" width=\"476\" height=\"238\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u30a8\u30e9\u30fc\u5024\u300e#N\/A\u300f\u3092\u300c(\u7a7a\u767d)\u300d\u306b\u7f6e\u63db<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff17\uff0e\u300e\u59d3<strong>\u300f<\/strong>\u3092\u78ba\u8a8d<\/span><\/strong><br>\u30a8\u30e9\u30fc\u5024<strong>\u300e#N\/A\u300f<\/strong>\u304c\u524a\u9664\u3055\u308c\u308b\u306e\u3067\u3001\u6b8b\u3063\u305f\u30bb\u30eb\u306e\u540d\u5b57\u304c\u300c\u59d3\u300d\u3068\u306a\u308a\u3046\u308b\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u3002\u307e\u3060\u3053\u306e\u6bb5\u968e\u3067\u306f\u3001\uff11\u884c\u306b\uff12\u3064\u306e\u300c\u59d3\u300d\u304c\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u3067\u306f\u6c17\u306b\u3057\u306a\u304f\u3066OK\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-divide-first-last-name-no-space-20.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-20.png\" alt=\"\u300c\u59d3\u300d\u3068\u306a\u308a\u3046\u308b\u30bb\u30eb\u3060\u3051\u304c\u6b8b\u308b\" class=\"wp-image-51187\" width=\"426\" height=\"359\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300c\u59d3\u300d\u3068\u306a\u308a\u3046\u308b\u30bb\u30eb\u3060\u3051\u304c\u6b8b\u308b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:49px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff18\uff0eLEFT\u95a2\u6570\u3092\u633f\u5165\u3057\u305f\u30bb\u30eb\u306b\u5024\u8cbc\u308a\u4ed8\u3051<\/span><\/strong><br>\u624b\u9806\uff17\u3067\u5b8c\u6210\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u3092\u30b3\u30d4\u30fc\u3057\u3066\u3001LEFT\u95a2\u6570\u304c\u633f\u5165\u3055\u308c\u305f\u30bb\u30eb\u7bc4\u56f2\u306b\u8cbc\u308a\u4ed8\u3051\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-divide-first-last-name-no-space-21.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-21.png\" alt=\"LEFT\u95a2\u6570\u3092\u633f\u5165\u3057\u305f\u30bb\u30eb\u306b\u5024\u8cbc\u308a\u4ed8\u3051\" class=\"wp-image-51188\" width=\"676\" height=\"225\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>LEFT\u95a2\u6570\u3092\u633f\u5165\u3057\u305f\u30bb\u30eb\u306b\u5024\u8cbc\u308a\u4ed8\u3051<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">VLOOKUP\u95a2\u6570\u3092\u633f\u5165\u3057\u305f\u30bb\u30eb\u7bc4\u56f2\u306f\u5229\u7528\u3057\u306a\u3044\u306e\u3067\u3001\u5217\u81ea\u4f53\u3092\u524a\u9664\u3057\u3066\u304f\u3060\u3055\u3044\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-divide-first-last-name-no-space-22-1.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-22-1.jpg\" alt=\"\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664\" class=\"wp-image-51190\" width=\"622\" height=\"189\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff19\uff0e\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664<\/span><\/strong><br>\u4eca\u56de\u8aac\u660e\u7528\u306b\u4f7f\u3063\u305f\u6c0f\u540d\u30ea\u30b9\u30c8\u3067\u306f\u3001\u300c\uff15\u300d\u300c\uff14\u300d\u306e\u5217\u306b\u306f\u4f55\u3082\u5165\u529b\u3055\u308c\u3066\u3044\u306a\u3044\u306e\u3067\u3001\u5217\u81ea\u4f53\u3092\u524a\u9664\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-divide-first-last-name-no-space-23.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-23.jpg\" alt=\"\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664\" class=\"wp-image-51191\" width=\"480\" height=\"249\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:56px\" 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\u4e0b\u306e\u56f3\u306e\u3088\u3046\u306b\u3001\u300c\u59d3\u300d\u306e\u5019\u88dc\u30ea\u30b9\u30c8\u304c\u5b8c\u6210\u3057\u307e\u3059\u3002\u300c\u5c0f\u91ce\u7530\u548c\u4e5f\u300d\u306e\u300c\u59d3\u300d\u304c\u3001\u300c\u5c0f\u91ce\u7530\u300d\u3068\u300c\u5c0f\u91ce\u300d\u306e\uff12\u3064\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u306a\u3069\u3001\u300c\u59d3\u300d\u3092\u7d5e\u308a\u5207\u308c\u3066\u3044\u307e\u305b\u3093\u304c\u3001\u3053\u306e\u898b\u51fa\u3057\u306e\u4f5c\u696d\u306f\u4ee5\u4e0a\u3067\u7d42\u4e86\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-divide-first-last-name-no-space-24.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-24.png\" alt=\"\u300c\u59d3\u300d\u306e\u5019\u88dc\u30ea\u30b9\u30c8\u304c\u5b8c\u6210\" class=\"wp-image-51192\" width=\"392\" height=\"294\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300c\u59d3\u300d\u306e\u5019\u88dc\u30ea\u30b9\u30c8\u304c\u5b8c\u6210<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:56px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u300e\u59d3\u300f\u3092\u7279\u5b9a<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u7d9a\u3044\u3066\u3001\u300c\u59d3\u300d\u3092\u7279\u5b9a(\u78ba\u5b9a)\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300c\u5c0f\u91ce\u7530\u548c\u4e5f\u300d\u306e\u300c\u59d3\u300d\u304c\u3001\u300c\u5c0f\u91ce\u7530\u300d\u3068\u300c\u5c0f\u91ce\u300d\u306e\uff12\u3064\u3001\u300c\u4eca\u4e95\u58ee\u592a\u300d\u306e\u300c\u59d3\u300d\u304c\u3001\u300c\u4eca\u4e95\u300d\u3068\u300c\u4eca\u300d\u306e\uff12\u3064\u5165\u529b\u3055\u308c\u3066\u3044\u307e\u3059\u304c\u3001\u57fa\u672c\u7684\u306b\u300c\u59d3\u300d\u3068\u300c\u540d\u300d\u3092\u5206\u304b\u308a\u3084\u3059\u304f\u540d\u524d\u304c\u4ed8\u3051\u3089\u308c\u308b\u306e\u3067\u3001<strong><span class=\"st-mymarker-s\">\u5de6\u5074\u304c\u6b63\u89e3<\/span><\/strong>\u306e\u53ef\u80fd\u6027\u304c\u9ad8\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u5de6\u5074\u304c\u6b63\u89e3\u3068\u3044\u3046\u524d\u63d0\u3067\u3001\u300c\u59d3\u300d\u3092\u7279\u5b9a(\u78ba\u5b9a)\u3055\u305b\u308b\u624b\u9806\u3092\u7d39\u4ecb\u3057\u3066\u3044\u304d\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-divide-first-last-name-no-space-25.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-25.png\" alt=\"\u59d3\u304c\uff12\u3064\u3042\u308b\u5834\u5408\u306f\u5de6\u5074\u304c\u6b63\u89e3\" class=\"wp-image-51193\" width=\"394\" height=\"350\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u59d3\u304c\uff12\u3064\u3042\u308b\u5834\u5408\u306f\u5de6\u5074\u304c\u6b63\u89e3<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:56px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff11\uff0e\u300c\u59d3\u300d\u5217\u3092\u8ffd\u52a0<\/span><\/strong><br>\u78ba\u5b9a\u3057\u305f\u300c\u59d3\u300d\u3092\u5165\u529b\u3059\u308b\u305f\u3081\u306e\u300e\u59d3\u300f\u5217\u3092\u8ffd\u52a0\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-divide-first-last-name-no-space-26.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-26.png\" alt=\"\u300e\u59d3\u300f\u5217\u3092\u8ffd\u52a0\" class=\"wp-image-51196\" width=\"424\" height=\"260\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u300e\u59d3\u300f\u5217\u3092\u8ffd\u52a0<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:47px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff12\uff0eIFS\u95a2\u6570\u3092\u633f\u5165<\/span><\/strong><br>\u624b\u9806\uff11\u3067\u4f5c\u6210\u3057\u305f\u300e\u59d3\u300f\u5217\u306b<strong>IFS\u95a2\u6570<\/strong>\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u305f\u3060\u3057\u3001IFS\u95a2\u6570\u306fExcel2016\u3001Excel2019\u3001Excel2021\u3001Office365\u306f\u5229\u7528\u51fa\u6765\u307e\u3059\u304c\u3001<strong><span class=\"st-mymarker-s-b\">\u4e00\u90e8\u306eExcel2016\u3084\u305d\u308c\u4ee5\u524d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u306f\u4f7f\u3046\u3053\u3068\u304c\u51fa\u6765\u307e\u305b\u3093<\/span><\/strong>\u3002\u305d\u306e\u5834\u5408\u306f\u3001IF\u95a2\u6570\u3067\u3082\u5bfe\u5fdc\u51fa\u6765\u307e\u3059\u306e\u3067\u3001IF\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u5834\u5408\u306f\u3001\u4e0b\u306e<strong>\u624b\u9806\uff12(\uff12)(\uff29\uff26\u95a2\u6570\u7248)<\/strong>\u307e\u3067\u8aad\u307f\u9032\u3081\u3066\u4e0b\u3055\u3044\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">IF\u95a2\u6570\u306e\u300eIF\u300f\u3068\u8907\u6570\u306e\u300eS\u300f\u306e\u5358\u8a9e\u306e\u3068\u304a\u308a\u3001IFS\u95a2\u6570\u306f\u30011\u3064\u307e\u305f\u306f\u8907\u6570\u306e\u6761\u4ef6\u304c\u6e80\u305f\u3055\u308c\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u3092\u5224\u5b9a\u3057\u3001\u6700\u521d\u306b\u6761\u4ef6\u3092\u6e80\u305f\u3059\u5834\u5408\u306e\u5024\u3092\u8fd4\u3057\u307e\u3059\u3002\u5f15\u6570\u3067\u5229\u7528\u3057\u3066\u3044\u308b<strong>\u300e&lt;&gt;\u300f\u306f\u3001\u201d\u4ee5\u5916\u201d\u3092\u8868\u3059\u6f14\u7b97\u5b50<\/strong>\u3067\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\">=IFS(C3&lt;&gt;&#8221;&#8221;,C3,D3&lt;&gt;&#8221;&#8221;,D3,E3&lt;&gt;&#8221;&#8221;,E3)<\/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-divide-first-last-name-no-space-27-1.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-27-1.jpg\" alt=\"IFS\u95a2\u6570\u3092\u633f\u5165\" class=\"wp-image-51199\" width=\"570\" height=\"279\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>IFS\u95a2\u6570\u3092\u633f\u5165<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u95a2\u6570\u306e\u8a2d\u5b9a\u304c\u96e3\u3057\u304f\u611f\u3058\u308b\u65b9\u306f\u3001\u6570\u5f0f\u30d0\u30fc\u306e\u5de6\u6a2a\u306e\u3010fx\u3011\u30dc\u30bf\u30f3\u3092\u62bc\u3057\u3066\u3001\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u753b\u9762\u304b\u3089\u5f15\u6570\u3092\u4e00\u3064\u305a\u3064\u8a2d\u5b9a\u3057\u305f\u65b9\u304c\u7c21\u5358\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\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-divide-first-last-name-no-space-28.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-28.png\" alt=\"IFS\u95a2\u6570\u306e\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u753b\u9762\" class=\"wp-image-51200\" width=\"572\" height=\"301\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>IFS\u95a2\u6570\u306e\u300c\u95a2\u6570\u306e\u5f15\u6570\u300d\u753b\u9762<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:45px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">ENTER\u3067\u95a2\u6570\u3092\u78ba\u5b9a\u3059\u308b\u3068\u3001\u6700\u3082\u5de6\u5074\u306b\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u5024\u304c\u300c\u59d3\u300d\u5217\u306b\u5165\u529b\u3055\u308c\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-divide-first-last-name-no-space-29.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-29.jpg\" alt=\"\u6700\u3082\u5de6\u5074\u306b\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u5024\u304c\u300c\u59d3\u300d\u5217\u306b\u5165\u529b\" class=\"wp-image-51201\" width=\"516\" height=\"316\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u6700\u3082\u5de6\u5074\u306b\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u5024\u304c\u300c\u59d3\u300d\u5217\u306b\u5165\u529b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff12(\uff12)\uff0eIF\u95a2\u6570\u3092\u633f\u5165<\/span><\/strong><br>\u624b\u9806\uff12\u3067IFS\u95a2\u6570\u3092\u5229\u7528\u51fa\u6765\u306a\u304b\u3063\u305f\u5834\u5408\u306f\u3001IF\u95a2\u6570\u3067\u5bfe\u5fdc\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u6700\u3082\u5de6\u5074\u306b\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u5024\u304c\u300c\u59d3\u300d\u5217\u306b\u5165\u529b\u3055\u308c\u308b\u3088\u3046\u3001\u4ee5\u4e0b\u306eIF\u95a2\u6570\u3092\u633f\u5165\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\"><strong><span class=\"oomozi\">=IF(C3=&#8221;&#8221;,IF(D3=&#8221;&#8221;,E3,D3),C3)<\/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-divide-first-last-name-no-space-30.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-30.jpg\" alt=\"IF\u95a2\u6570\u3092\u633f\u5165\" class=\"wp-image-51202\" width=\"576\" height=\"309\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>IF\u95a2\u6570\u3092\u633f\u5165<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">ENTER\u3067\u95a2\u6570\u3092\u78ba\u5b9a\u3059\u308b\u3068\u3001IFS\u95a2\u6570\u306e\u7d50\u679c\u3068\u540c\u3058\u304f\u3001\u6700\u3082\u5de6\u5074\u306b\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u5024\u304c\u300c\u59d3\u300d\u5217\u306b\u5165\u529b\u3055\u308c\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-divide-first-last-name-no-space-31.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-31.png\" alt=\"\u6700\u3082\u5de6\u5074\u306b\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u5024\u304c\u300c\u59d3\u300d\u5217\u306b\u5165\u529b\" class=\"wp-image-51203\" width=\"464\" height=\"289\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u6700\u3082\u5de6\u5074\u306b\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u5024\u304c\u300c\u59d3\u300d\u5217\u306b\u5165\u529b<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:63px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">IFS\u95a2\u6570\u3084IF\u95a2\u6570\u306e\u5177\u4f53\u7684\u306a\u4f7f\u3044\u65b9\u3092\u4ee5\u4e0b\u306e\u8a18\u4e8b\u3067\u3082\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u305c\u3072\u53c2\u8003\u306b\u3057\u3066\u307f\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=22573\" 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\/10\/excel-gradereport-5stages-evaluation-1000x541.png\" alt=\"\" width=\"100\" height=\"100\" \/><\/dt><dd><p class=\"st-cardbox-t\">\u3010\u30a8\u30af\u30bb\u30eb\u3011\u6210\u7e3e\u8868\u3092\u70b9\u6570\u5225\u306b\u81ea\u52d5\u3067\uff15\u6bb5\u968e\u8a55\u4fa1\u3059\u308b\u65b9\u6cd5\u3002\u8907\u6570\u6761\u4ef6\u306e\u5bfe\u51e6\u65b9\u6cd5<\/p><div class=\"st-card-excerpt smanone\"><p>\u5b66\u6821\u306e\u30c6\u30b9\u30c8\u306a\u3069\u306e\u6210\u7e3e\u8868\u3092\u70b9\u6570\u306b\u5fdc\u3058\u3066\u3001\u201d\uff11\uff5e\uff15\u201d\u306e\uff15\u6bb5\u968e\u8a55\u4fa1\u3057\u305f\u308a\u201dA\uff5eE\u201d\u306e\uff15\u6bb5\u968e\u8a55\u4fa1\u3059\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002 \u30c7\u30fc\u30bf\u91cf &#8230; <\/p><\/div><\/dd><\/dl><\/div><\/a><\/div>\n<\/div><\/figure>\n\n\n\n<div style=\"height:44px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff13\uff0eIFS\u95a2\u6570(\u3082\u3057\u304f\u306fIF\u95a2\u6570)\u3092\u30b3\u30d4\u30da<\/span><\/strong><br>\u624b\u9806\uff12\u3067\u633f\u5165\u3057\u305fIFS\u95a2\u6570(\u3082\u3057\u304f\u306fIF\u95a2\u6570)\u3092\u4e0b\u306e\u30bb\u30eb\u306b\u30b3\u30d4\u30da\u3059\u308b\u3068\u3001\u300c\u59d3\u300d\u304c\u78ba\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-divide-first-last-name-no-space-32.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-32.png\" alt=\"IFS\u95a2\u6570\u3082\u3057\u304f\u306fIF\u95a2\u6570\u3092\u30b3\u30d4\u30da\u3057\u3066\u300e\u59d3\u300f\u3092\u78ba\u5b9a\" class=\"wp-image-51204\" width=\"534\" height=\"310\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>IFS\u95a2\u6570\u3082\u3057\u304f\u306fIF\u95a2\u6570\u3092\u30b3\u30d4\u30da\u3057\u3066\u300e\u59d3\u300f\u3092\u78ba\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:51px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u6c0f\u540d\u30ea\u30b9\u30c8\u306e\u300e\u540d\u300f\u3092\u7279\u5b9a<\/h2>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">\u300e\u59d3\u300f\u304c\u78ba\u5b9a\u3057\u305f\u306e\u3067\u3001\u6b8b\u308a\u306f\u300e\u540d\u300f\u3092\u78ba\u5b9a\u3059\u308c\u3070\u4f5c\u696d\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u6b21\u306f\u3001RIGHT\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3001<strong>\u6c0f\u540d\u306e\u672b\u5c3e\u304b\u3089\u5fc5\u8981\u306a\u6587\u5b57\u6570\u3092\u629c\u304d\u53d6\u308a\u307e\u3059<\/strong>\u3002<\/p>\n\n\n\n<div style=\"height:56px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff11\uff0e\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664<\/span><\/strong><br>IFS\u95a2\u6570(\u3082\u3057\u304f\u306fIF\u95a2\u6570)\u304c\u633f\u5165\u3055\u308c\u3066\u3044\u308b\u5217\u306f<strong>\u5024\u8cbc\u308a\u4ed8\u3051\u3057\u3066\u3001\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664<\/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-divide-first-last-name-no-space-33.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-33.png\" alt=\"\u5024\u8cbc\u308a\u4ed8\u3051\u3057\u3066\u3001\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664\" class=\"wp-image-51205\" width=\"516\" height=\"341\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u5024\u8cbc\u308a\u4ed8\u3051\u3057\u3066\u3001\u4e0d\u8981\u306a\u5217\u3092\u524a\u9664<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:56px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff12\uff0eRIGHT\u95a2\u6570\u3092\u633f\u5165<\/span><\/strong><br>\u4ee5\u4e0b\u306eRIGHT\u95a2\u6570\u3092\u633f\u5165\u3057\u307e\u3059\u3002RIGHT\u95a2\u6570\u306e\u4e2d\u306b\u6587\u5b57\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u308bLEN\u95a2\u6570\u3092\u633f\u5165\u3057\u3066\u3001\u629c\u304d\u53d6\u308b\u300e\u540d\u300f\u306e\u6587\u5b57\u6570\u3092\u81ea\u52d5\u3067\u8a08\u7b97\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><span class=\"oomozi\">=RIGHT(<span style=\"color:#0693e3\" class=\"tadv-color\">B3<\/span>,LEN(<span style=\"color:#0693e3\" class=\"tadv-color\">B3<\/span>)-LEN(<span style=\"color:#e92f3d\" class=\"tadv-color\">C3<\/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-divide-first-last-name-no-space-34.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-34.jpg\" alt=\"RIGHT\u95a2\u6570\u3092\u633f\u5165\" class=\"wp-image-51206\" width=\"482\" height=\"330\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>RIGHT\u95a2\u6570\u3092\u633f\u5165<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:52px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\">ENTER\u3067\u95a2\u6570\u3092\u78ba\u5b9a\u3059\u308b\u3068\u3001\u300e\u592a\u90ce\u300f\u3068\u8868\u793a\u3055\u308c\u3001\u300e\u540d\u300f\u304c\u78ba\u5b9a\u3055\u308c\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-divide-first-last-name-no-space-35.jpg\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-35.jpg\" alt=\"RIGHT\u95a2\u6570\u3067\u300e\u540d\u300f\u304c\u78ba\u5b9a\" class=\"wp-image-51207\" width=\"458\" height=\"305\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>RIGHT\u95a2\u6570\u3067\u300e\u540d\u300f\u304c\u78ba\u5b9a<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:45px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff13\uff0eRIGHT\u95a2\u6570\u3092\u30b3\u30d4\u30da<\/span><\/strong><br><\/span><\/strong>\u624b\u9806\uff12\u3067\u633f\u5165\u3057\u305fRIGHT\u95a2\u6570\u3092\u4e0b\u306e\u30bb\u30eb\u306b\u30b3\u30d4\u30da\u3059\u308b\u3068\u3001\u5168\u3066\u306e\u30bb\u30eb\u306e\u300c\u540d\u300d\u304c\u78ba\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-divide-first-last-name-no-space-36.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-36.png\" alt=\"RIGHT\u95a2\u6570\u3092\u30b3\u30d4\u30da\" class=\"wp-image-51208\" width=\"466\" height=\"328\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>RIGHT\u95a2\u6570\u3092\u30b3\u30d4\u30da<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-st-margin-bottom has-st-margin-bottom-2\"><strong><span style=\"text-decoration: underline\" class=\"underline\">\u624b\u9806\uff14\uff0e\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306e\u5206\u89e3\u304c\u5b8c\u4e86<\/span><br><\/strong>RIGHT\u95a2\u6570\u304c\u633f\u5165\u3055\u308c\u305f\u30bb\u30eb\u3092\u5024\u8cbc\u308a\u4ed8\u3051\u3059\u308c\u3070\u3001\u3059\u3079\u3066\u306e\u6c0f\u540d\u306e\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306e\u5206\u89e3\u304c\u5b8c\u4e86\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-divide-first-last-name-no-space-37.png\"><img decoding=\"async\" src=\"https:\/\/www.excel-no-mori-blog.jp\/wp-content\/uploads\/2024\/01\/excel-divide-first-last-name-no-space-37.png\" alt=\"\u3059\u3079\u3066\u306e\u6c0f\u540d\u306e\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306e\u5206\u89e3\u304c\u5b8c\u4e86\" class=\"wp-image-51209\" width=\"358\" height=\"401\"\/><\/a><figcaption class=\"wp-element-caption\"><strong>\u3059\u3079\u3066\u306e\u6c0f\u540d\u306e\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306e\u5206\u89e3\u304c\u5b8c\u4e86<\/strong><\/figcaption><\/figure><\/div>\n\n\n<div style=\"height:71px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Excel(\u30a8\u30af\u30bb\u30eb)\u3067\u30b9\u30da\u30fc\u30b9\u304c\u3042\u308b\u6c0f\u540d\u30ea\u30b9\u30c8\u3092\u300e\u59d3\u300f\u3068\u300e\u540d\u300f\u306b\u5206\u3051\u308b\u65b9\u6cd5\u3092\u3010\u3010\u30a8\u30af\u30bb\u30eb\u3011\u6c0f\u540d\u306e\u300e\u59d3\u300f\u3068\u300e\u540d\u300f(\u300e\u82d7\u5b57 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":51165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,36],"tags":[],"class_list":["post-22904","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-36"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/22904","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=22904"}],"version-history":[{"count":0,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/posts\/22904\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=\/wp\/v2\/media\/51165"}],"wp:attachment":[{"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-no-mori-blog.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}