{"id":74121,"date":"2024-11-15T01:51:36","date_gmt":"2024-11-15T01:51:36","guid":{"rendered":"https:\/\/goodwriterz.com\/site\/?p=74121"},"modified":"2024-11-15T01:51:36","modified_gmt":"2024-11-15T01:51:36","slug":"%d9%85%d8%a7-%d8%a7%d9%84%d8%b0%d9%8a-%d9%8a%d8%ac%d8%a8-%d8%b9%d9%84%d9%8a%d9%83-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85%d9%87-%d9%81%d9%8a-excel%d8%9f","status":"publish","type":"post","link":"https:\/\/goodwriterz.com\/site\/%d9%85%d8%a7-%d8%a7%d9%84%d8%b0%d9%8a-%d9%8a%d8%ac%d8%a8-%d8%b9%d9%84%d9%8a%d9%83-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85%d9%87-%d9%81%d9%8a-excel%d8%9f\/","title":{"rendered":"\u0645\u0627 \u0627\u0644\u0630\u064a \u064a\u062c\u0628 \u0639\u0644\u064a\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647 \u0641\u064a Excel\u061f"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u062d\u062a\u0648\u064a\u0627\u062a<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/goodwriterz.com\/site\/%d9%85%d8%a7-%d8%a7%d9%84%d8%b0%d9%8a-%d9%8a%d8%ac%d8%a8-%d8%b9%d9%84%d9%8a%d9%83-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85%d9%87-%d9%81%d9%8a-excel%d8%9f\/#%D8%A8%D8%A7%D8%AE%D8%AA%D8%B5%D8%A7%D8%B1_CONCAT_%D9%85%D9%82%D8%A7%D8%A8%D9%84_TEXTJOIN\" title=\"\u0628\u0627\u062e\u062a\u0635\u0627\u0631: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN\">\u0628\u0627\u062e\u062a\u0635\u0627\u0631: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/goodwriterz.com\/site\/%d9%85%d8%a7-%d8%a7%d9%84%d8%b0%d9%8a-%d9%8a%d8%ac%d8%a8-%d8%b9%d9%84%d9%8a%d9%83-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85%d9%87-%d9%81%d9%8a-excel%d8%9f\/#%D9%81%D9%8A_%D8%A7%D9%84%D9%85%D9%85%D8%A7%D8%B1%D8%B3%D8%A9_%D8%A7%D9%84%D8%B9%D9%85%D9%84%D9%8A%D8%A9_CONCAT_%D9%85%D9%82%D8%A7%D8%A8%D9%84_TEXTJOIN\" title=\"\u0641\u064a \u0627\u0644\u0645\u0645\u0627\u0631\u0633\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0629: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN\">\u0641\u064a \u0627\u0644\u0645\u0645\u0627\u0631\u0633\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0629: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/goodwriterz.com\/site\/%d9%85%d8%a7-%d8%a7%d9%84%d8%b0%d9%8a-%d9%8a%d8%ac%d8%a8-%d8%b9%d9%84%d9%8a%d9%83-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85%d9%87-%d9%81%d9%8a-excel%d8%9f\/#%D9%83%D9%88%D9%86%D9%83%D8%A7%D8%AA\" title=\"\u0643\u0648\u0646\u0643\u0627\u062a\">\u0643\u0648\u0646\u0643\u0627\u062a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/goodwriterz.com\/site\/%d9%85%d8%a7-%d8%a7%d9%84%d8%b0%d9%8a-%d9%8a%d8%ac%d8%a8-%d8%b9%d9%84%d9%8a%d9%83-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85%d9%87-%d9%81%d9%8a-excel%d8%9f\/#%D8%B1%D8%A8%D8%B7_%D9%86%D8%B5%D9%8A\" title=\"\u0631\u0628\u0637 \u0646\u0635\u064a\">\u0631\u0628\u0637 \u0646\u0635\u064a<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/goodwriterz.com\/site\/%d9%85%d8%a7-%d8%a7%d9%84%d8%b0%d9%8a-%d9%8a%d8%ac%d8%a8-%d8%b9%d9%84%d9%8a%d9%83-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85%d9%87-%d9%81%d9%8a-excel%d8%9f\/#%D8%A8%D8%A7%D8%AE%D8%AA%D8%B5%D8%A7%D8%B1_CONCAT_%D9%85%D9%82%D8%A7%D8%A8%D9%84_TEXTJOIN-2\" title=\"\u0628\u0627\u062e\u062a\u0635\u0627\u0631: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN\">\u0628\u0627\u062e\u062a\u0635\u0627\u0631: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN<\/a><\/li><\/ul><\/nav><\/div>\n<div id=\"article-hidden-content\">\n<section class=\"emaki-custom-block emaki-custom-note\">\n<div class=\"emaki-custom note\" id=\"custom_block_1\">\n<div class=\"custom_block-content note\">\n<p>\u062a\u0645\u062a \u0625\u0636\u0627\u0641\u0629 CONCAT \u0648TEXTJOIN \u0625\u0644\u0649 Excel \u0641\u064a \u0639\u0627\u0645 2019\u060c \u0644\u0630\u0644\u0643 \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0633\u062a\u062e\u062f\u0645 \u0625\u0635\u062f\u0627\u0631\u064b\u0627 \u0623\u0642\u062f\u0645\u060c \u0641\u0642\u062f \u0644\u0627 \u062a\u062a\u0645\u0643\u0646 \u0645\u0646 \u0627\u0644\u0648\u0635\u0648\u0644 \u0625\u0644\u0649 \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u0627\u0626\u0641.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":240} --><\/section>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":240} --><br \/>\n<!-- No winning ad found for zone: native in content! --><\/p>\n<h2 id=\"in-short-concat-vs-textjoin\"><span class=\"ez-toc-section\" id=\"%D8%A8%D8%A7%D8%AE%D8%AA%D8%B5%D8%A7%D8%B1_CONCAT_%D9%85%D9%82%D8%A7%D8%A8%D9%84_TEXTJOIN\"><\/span>  \u0628\u0627\u062e\u062a\u0635\u0627\u0631: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0643\u0644\u0627\u0647\u0645\u0627 \u064a\u062c\u0645\u0639 \u0627\u0644\u0646\u0635 \u0645\u0646 \u062e\u0644\u0627\u064a\u0627 \u0645\u062a\u0639\u062f\u062f\u0629 \u0641\u064a \u062e\u0644\u064a\u0629 \u0648\u0627\u062d\u062f\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":287} --><\/p>\n<p>\u0648\u0641\u0642 <a target=\"_blank\" href=\"https:\/\/dictionary.cambridge.org\/dictionary\/english\/concatenate\" rel=\"noopener noreferrer\">\u0642\u0627\u0645\u0648\u0633 \u0643\u0627\u0645\u0628\u0631\u064a\u062f\u062c<\/a>\u060c \u0627\u0644\u0641\u0639\u0644 <em>\u0644\u062a\u0633\u0644\u0633\u0644<\/em> \u064a\u0639\u0646\u064a &#8220;\u062c\u0645\u0639 \u0627\u0644\u0623\u0634\u064a\u0627\u0621 \u0645\u0639\u064b\u0627 \u0643\u0633\u0644\u0633\u0644\u0629 \u0645\u062a\u0635\u0644\u0629&#8221;\u060c \u0648CONCAT<strong> <\/strong>\u062a\u0642\u0648\u0645 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0628\u0630\u0644\u0643 \u0628\u0627\u0644\u0636\u0628\u0637 \u0639\u0646 \u0637\u0631\u064a\u0642 \u062c\u0645\u0639 \u0645\u0631\u0627\u062c\u0639 \u0627\u0644\u0646\u0635 \u0623\u0648 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0645\u0639\u064b\u0627 \u0641\u064a \u0633\u0644\u0633\u0644\u0629 \u0645\u0633\u062a\u0645\u0631\u0629:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":519} --><\/p>\n<pre>=CONCAT(<em>a<\/em>,<em>b<\/em>,<em>c<\/em>)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":533} --><\/p>\n<p>\u0623\u064a\u0646 <em>\u0623<\/em>, <em>\u0628<\/em>\u060c \u0648 <em>\u062c<\/em> \u0647\u064a \u0645\u0631\u0627\u062c\u0639 \u0627\u0644\u0646\u0635 \u0623\u0648 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u062a\u064a \u062a\u0631\u064a\u062f \u062f\u0645\u062c\u0647\u0627 \u0641\u064a \u062e\u0644\u064a\u0629 \u0648\u0627\u062d\u062f\u0629. \u0642\u0645 \u0628\u0625\u062d\u0627\u0637\u0629 \u0623\u064a \u0642\u064a\u0645 \u0646\u0635\u064a\u0629 (\u0628\u0645\u0627 \u0641\u064a \u0630\u0644\u0643 \u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u062a\u0631\u0642\u064a\u0645 \u0648\u0627\u0644\u0645\u0633\u0627\u0641\u0627\u062a) \u0628\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0642\u062a\u0628\u0627\u0633 \u0645\u0632\u062f\u0648\u062c\u0629. \u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0645\u0627 \u064a\u0635\u0644 \u0625\u0644\u0649 252 \u0645\u0631\u062c\u0639\u064b\u0627 \u0623\u0648 \u0633\u0644\u0633\u0644\u0629 \u0646\u0635\u064a\u0629 \u0647\u0646\u0627.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":750} --><\/p>\n<p>\u0625\u0630\u0627 \u062a\u0645\u062a \u0627\u0644\u0625\u0634\u0627\u0631\u0629 \u0625\u0644\u0649 \u062e\u0644\u0627\u064a\u0627 \u0641\u0627\u0631\u063a\u0629 \u0641\u064a \u0635\u064a\u063a\u0629 CONCAT\u060c \u0641\u0633\u064a\u062a\u0645 \u062a\u062c\u0627\u0647\u0644\u0647\u0627 \u0641\u064a \u0627\u0644\u0625\u062e\u0631\u0627\u062c \u0645\u0627 \u0644\u0645 \u064a\u062a\u0645 \u0648\u0636\u0639\u0647\u0627 \u0628\u064a\u0646 \u0627\u0644\u0641\u0648\u0627\u0635\u0644.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":863} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":863,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":37,\"nextBlockCount\":199,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1062} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":900} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":0} --><\/p>\n<p><em>\u0631\u0628\u0637 \u0646\u0635\u064a <\/em>\u064a\u0642\u0648\u0645 \u0628\u0646\u0641\u0633 \u0648\u0638\u064a\u0641\u0629 CONCAT\u060c \u0644\u0643\u0646 \u0627\u0644\u0645\u062d\u062f\u062f \u064a\u0633\u0645\u062d \u0644\u0643 \u0628\u0627\u062e\u062a\u064a\u0627\u0631 \u0645\u0627 \u062a\u0631\u064a\u062f \u0625\u062f\u0631\u0627\u062c\u0647 \u0628\u064a\u0646 \u0643\u0644 \u0639\u0646\u0635\u0631 \u0641\u064a \u0627\u0644\u0633\u0644\u0633\u0644\u0629. \u064a\u0645\u0646\u062d\u0643 TEXTJOIN \u0623\u064a\u0636\u064b\u0627 \u062e\u064a\u0627\u0631 \u062a\u0636\u0645\u064a\u0646 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0641\u0627\u0631\u063a\u0629 \u0623\u0648 \u0627\u0633\u062a\u0628\u0639\u0627\u062f\u0647\u0627.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":162} --><\/p>\n<pre>=TEXTJOIN(<em>w<\/em>, <em>x<\/em>, <em>y<\/em>)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":180} --><\/p>\n<p>\u0623\u064a\u0646 <em>\u062b<\/em> \u0647\u0648 \u0627\u0644\u0641\u0627\u0635\u0644\u060c <em>\u0633<\/em> \u062a\u0643\u0648\u0646 TRUE \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u062a\u062c\u0627\u0647\u0644 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0641\u0627\u0631\u063a\u0629 (\u0623\u0648 FALSE \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u062a\u0636\u0645\u064a\u0646 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0641\u0627\u0631\u063a\u0629)\u060c \u0648 <em>\u0630<\/em> \u0647\u0648 \u0627\u0644\u0623\u0648\u0644 \u0645\u0646 \u0628\u064a\u0646 \u0645\u0627 \u064a\u0635\u0644 \u0625\u0644\u0649 252 \u0645\u0631\u062c\u0639\u064b\u0627 \u0623\u0648 \u0633\u0644\u0633\u0644\u0629 \u0646\u0635\u064a\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":356} --><\/p>\n<section class=\"emaki-custom-block emaki-custom-note\">\n<div class=\"emaki-custom note\" id=\"custom_block_11\">\n<div class=\"custom_block-content note\">\n<p>\u0623<br \/>\n<a target=\"_blank\" href=\"https:\/\/dictionary.cambridge.org\/dictionary\/english\/delimiter\" rel=\"noopener noreferrer\">\u0645\u062d\u062f\u062f<\/a><br \/>\n \u0647\u064a &#8220;\u0639\u0644\u0627\u0645\u0629 \u0623\u0648 \u0631\u0645\u0632 \u064a\u0633\u062a\u062e\u062f\u0645 \u0644\u0625\u0638\u0647\u0627\u0631 \u0628\u062f\u0627\u064a\u0629 \u0623\u0648 \u0646\u0647\u0627\u064a\u0629 \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0627\u0644\u0645\u0646\u0641\u0635\u0644\u0629.&#8221;<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":596} --><\/section>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":596} --><\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":596} --><\/p>\n<h2 id=\"in-practice-concat-vs-textjoin\"><span class=\"ez-toc-section\" id=\"%D9%81%D9%8A_%D8%A7%D9%84%D9%85%D9%85%D8%A7%D8%B1%D8%B3%D8%A9_%D8%A7%D9%84%D8%B9%D9%85%D9%84%D9%8A%D8%A9_CONCAT_%D9%85%D9%82%D8%A7%D8%A8%D9%84_TEXTJOIN\"><\/span>  \u0641\u064a \u0627\u0644\u0645\u0645\u0627\u0631\u0633\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0629: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0639\u0648\u0646\u0627 \u0646\u0644\u0642\u064a \u0646\u0638\u0631\u0629 \u0623\u0628\u0639\u062f \u0639\u0644\u0649 \u0647\u0630\u0647 \u0645\u0639 \u0628\u0639\u0636 \u0627\u0644\u0623\u0645\u062b\u0644\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":645} --><\/p>\n<h3 id=\"concat\"><span class=\"ez-toc-section\" id=\"%D9%83%D9%88%D9%86%D9%83%D8%A7%D8%AA\"><\/span>  \u0643\u0648\u0646\u0643\u0627\u062a <span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0641\u064a \u0627\u0644\u0645\u062b\u0627\u0644 \u0623\u062f\u0646\u0627\u0647\u060c<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":666} --><\/p>\n<pre>=CONCAT(A1,B1,C1)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":683} --><\/p>\n<p>\u064a\u062c\u0645\u0639 \u0643\u0627\u0641\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0645\u0646 A1 \u0625\u0644\u0649 C1 \u0641\u064a \u0627\u0644\u062e\u0644\u064a\u0629 B3. \u0643\u0627\u0646 \u0645\u0646 \u0627\u0644\u0645\u0645\u0643\u0646 \u0623\u0646 \u0646\u0643\u062a\u0628 \u0623\u064a\u0636\u064b\u0627<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":761} --><\/p>\n<pre>=CONCAT(A1:C1)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":775} --><\/p>\n<p>\u0646\u0638\u0631\u064b\u0627 \u0644\u0623\u0646 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0645\u062a\u062c\u0627\u0648\u0631\u0629\u060c \u0648\u0644\u0645 \u0646\u0637\u0644\u0628 \u0623\u064a \u0642\u064a\u0645 \u0623\u0648 \u0639\u0644\u0627\u0645\u0627\u062a \u062a\u0631\u0642\u064a\u0645 \u0623\u0648 \u0645\u0633\u0627\u0641\u0627\u062a \u0628\u064a\u0646 \u0627\u0644\u0623\u0631\u0642\u0627\u0645 \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a \u0627\u0644\u062e\u0644\u064a\u0629 B3.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":892} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":892,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":8,\"nextBlockCount\":240,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1132} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":900} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":0} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\" :40%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/\u0645\u0627-\u0627\u0644\u0630\u064a-\u064a\u062c\u0628-\u0639\u0644\u064a\u0643-\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647-\u0641\u064a-Excel\u061f.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure><picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"300\" loading=\"lazy\" decoding=\"async\" alt=\"\u062c\u062f\u0648\u0644 \u0628\u064a\u0627\u0646\u0627\u062a Excel \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0648\u0638\u064a\u0641\u0629 CONTACT \u0648\u0627\u0644\u0645\u062e\u0631\u062c\u0627\u062a \u0627\u0644\u0646\u0627\u062a\u062c\u0629.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/\u0645\u0627-\u0627\u0644\u0630\u064a-\u064a\u062c\u0628-\u0639\u0644\u064a\u0643-\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647-\u0641\u064a-Excel\u061f.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/%D9%85%D8%A7-%D8%A7%D9%84%D8%B0%D9%8A-%D9%8A%D8%AC%D8%A8-%D8%B9%D9%84%D9%8A%D9%83-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85%D9%87-%D9%81%D9%8A-Excel%D8%9F.png?resize=750%2C300&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\"> <\/picture> <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":232} --><\/p>\n<p>  \u0648\u0647\u0646\u0627 \u0645\u062b\u0627\u0644 \u0622\u062e\u0631:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":256} --><\/p>\n<pre>=CONCAT(A1,\" \",A2,\" \",A3)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":281} --><\/p>\n<p>\u0648\u0627\u0644\u062a\u064a \u0645\u0646 \u0634\u0623\u0646\u0647\u0627 \u0625\u0636\u0627\u0641\u0629 \u0645\u0633\u0627\u0641\u0629 \u0628\u064a\u0646 \u0643\u0644 \u0642\u064a\u0645\u0629 \u064a\u062a\u0645 \u0633\u062d\u0628\u0647\u0627 \u0645\u0646 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 A1 \u0625\u0644\u0649 C1. \u062a\u0630\u0643\u0631 \u0623\u0646\u0647 \u064a\u062c\u0628 \u0641\u0635\u0644 \u0643\u0644 \u0648\u0633\u064a\u0637\u0629 \u0628\u0641\u0627\u0635\u0644\u0629\u060c \u0648\u064a\u062c\u0628 \u0648\u0636\u0639 \u0623\u064a \u0642\u064a\u0645 \u0646\u0635\u064a\u0629 (\u0628\u0645\u0627 \u0641\u064a \u0630\u0644\u0643 \u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u062a\u0631\u0642\u064a\u0645 \u0648\u0627\u0644\u0645\u0633\u0627\u0641\u0627\u062a) \u0628\u064a\u0646 \u0639\u0644\u0627\u0645\u062a\u064a \u0627\u0642\u062a\u0628\u0627\u0633 \u0645\u0632\u062f\u0648\u062c\u062a\u064a\u0646.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":496} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\" :40%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635488_924_\u0645\u0627-\u0627\u0644\u0630\u064a-\u064a\u062c\u0628-\u0639\u0644\u064a\u0643-\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647-\u0641\u064a-Excel\u061f.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure><picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"300\" loading=\"lazy\" decoding=\"async\" alt=\"\u062c\u062f\u0648\u0644 \u0628\u064a\u0627\u0646\u0627\u062a Excel \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0648\u0638\u064a\u0641\u0629 CONTACT \u0645\u0639 \u0645\u0633\u0627\u0641\u0627\u062a \u0648\u0627\u0644\u0645\u062e\u0631\u062c\u0627\u062a \u0627\u0644\u0646\u0627\u062a\u062c\u0629.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635488_924_\u0645\u0627-\u0627\u0644\u0630\u064a-\u064a\u062c\u0628-\u0639\u0644\u064a\u0643-\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647-\u0641\u064a-Excel\u061f.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635488_924_%D9%85%D8%A7-%D8%A7%D9%84%D8%B0%D9%8A-%D9%8A%D8%AC%D8%A8-%D8%B9%D9%84%D9%8A%D9%83-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85%D9%87-%D9%81%D9%8A-Excel%D8%9F.png?resize=750%2C300&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\"> <\/picture> <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":736} --><\/p>\n<p>  \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 CONCAT \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0633\u064a\u0646\u0627\u0631\u064a\u0648\u0647\u0627\u062a:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":777} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":777,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":123,\"nextBlockCount\":530,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1307} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":900} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":0} --><\/p>\n<ul>\n<li>  \u0644\u062f\u064a\u0643 \u0627\u0644\u0623\u0633\u0645\u0627\u0621 \u0627\u0644\u0623\u0648\u0644\u0649 \u0644\u0644\u0623\u0634\u062e\u0627\u0635 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f A\u060c \u0648\u0623\u0633\u0645\u0627\u0626\u0647\u0645 \u0627\u0644\u062b\u0627\u0646\u064a\u0629 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f B\u060c \u0648\u062a\u0631\u064a\u062f \u062f\u0645\u062c\u0647\u0645 (\u0645\u0641\u0635\u0648\u0644\u064a\u0646 \u0628\u0645\u0633\u0627\u0641\u0629) \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f C. <\/li>\n<li>  \u062a\u0631\u064a\u062f \u0623\u062a\u0645\u062a\u0629 \u0627\u0644\u062c\u0645\u0644 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0642\u064a\u0645 \u0627\u0644\u062e\u0644\u0627\u064a\u0627. \u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u0642\u062f \u064a\u0643\u0648\u0646 \u0644\u062f\u064a\u0643 \u0627\u0633\u0645 \u0634\u062e\u0635 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f A \u0648\u0639\u0645\u0631\u0647 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f B\u060c \u0648\u062a\u0631\u064a\u062f \u0625\u0646\u0634\u0627\u0621 \u062c\u0645\u0644 \u0644\u0643\u0644 \u0634\u062e\u0635 \u062a\u0642\u0648\u0644 &#8220;(\u0627\u0644\u0627\u0633\u0645) \u0647\u0648 (\u0627\u0644\u0639\u0645\u0631) \u0633\u0646\u0629&#8221; \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f C. <\/li>\n<li>  \u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0625\u0646\u0634\u0627\u0621 \u0645\u0641\u0627\u062a\u064a\u062d \u0645\u0631\u0643\u0628\u0629 \u0648\u0645\u0631\u0643\u0628\u0629\u060c \u062d\u064a\u062b \u064a\u0643\u0648\u0646 \u0644\u062f\u064a\u0643 \u0642\u0627\u0626\u0645\u062a\u064a\u0646 \u0645\u0646 \u0627\u0644\u0623\u0631\u0642\u0627\u0645 \u0627\u0644\u0645\u0631\u062c\u0639\u064a\u0629 \u0648\u062a\u0631\u064a\u062f \u0625\u0646\u0634\u0627\u0621 \u0642\u0627\u0626\u0645\u0629 \u062b\u0627\u0644\u062b\u0629 \u062a\u062c\u0645\u0639 \u0628\u064a\u0646 \u0627\u0644\u0627\u062b\u0646\u064a\u0646. <\/li>\n<\/ul>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":407} --><\/p>\n<section class=\"emaki-custom-block emaki-custom-note\">\n<div class=\"emaki-custom note\" id=\"custom_block_27\">\n<div class=\"custom_block-content note\">\n<p>\u062a\u062d\u0644 CONCAT \u0645\u062d\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 CONCATENATE\u060c \u0648\u0627\u0644\u062a\u064a \u064a\u062a\u0645 \u0627\u0644\u062a\u062e\u0644\u0635 \u0645\u0646\u0647\u0627 \u062a\u062f\u0631\u064a\u062c\u064a\u064b\u0627. \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 CONCATENATE\u060c \u0644\u0627 \u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u0639\u0645\u0644 \u0645\u0639 \u0627\u0644\u0645\u0635\u0641\u0648\u0641\u0627\u062a (\u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c A1:A40)\u060c \u0641\u0642\u0637 \u0645\u0631\u0627\u062c\u0639 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0641\u0631\u062f\u064a\u0629 (\u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c A1\u060c A2\u060c A3&#8230;). \u0644\u0630\u0627\u060c \u0641\u0645\u0646 \u0627\u0644\u0623\u0641\u0636\u0644 \u062a\u062c\u0646\u0628 CONCATENATE \u062a\u0645\u0627\u0645\u064b\u0627\u060c \u0648\u0627\u0644\u0630\u0647\u0627\u0628 \u0625\u0644\u0649 CONCAT \u0645\u0646 \u0627\u0644\u0622\u0646 \u0641\u0635\u0627\u0639\u062f\u064b\u0627.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":647} --><\/section>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":647} --><\/p>\n<h3 id=\"textjoin\"><span class=\"ez-toc-section\" id=\"%D8%B1%D8%A8%D8%B7_%D9%86%D8%B5%D9%8A\"><\/span>  \u0631\u0628\u0637 \u0646\u0635\u064a <span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0644\u0646\u0623\u062e\u0630 \u0646\u0641\u0633 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u0644\u0643\u0646 \u0647\u0630\u0647 \u0627\u0644\u0645\u0631\u0629\u060c \u0646\u0631\u064a\u062f \u0625\u0636\u0627\u0641\u0629 \u0643\u0644\u0645\u0629 &#8220;\u0648&#8221; \u0628\u064a\u0646 \u0643\u0644 \u0631\u0642\u0645.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":741} --><\/p>\n<p>\u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 CONCAT \u0648\u062a\u0643\u0631\u0627\u0631 &#8220;\u0648&#8221; \u0628\u064a\u0646 \u0643\u0644 \u0642\u064a\u0645\u0629\u060c \u064a\u0645\u0643\u0646\u0646\u0627 \u0627\u0644\u0643\u062a\u0627\u0628\u0629 <strong>\u0648 <\/strong>\u0643\u0645\u062d\u062f\u062f (\u0627\u0644\u0648\u0633\u064a\u0637\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 \u062f\u0627\u062e\u0644 \u0627\u0644\u0623\u0642\u0648\u0627\u0633) \u0645\u0639 \u0627\u0644\u062f\u0627\u0644\u0629 TEXTJOIN.<\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":908} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":900,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><\/p>\n<pre>=TEXTJOIN(\" and \",TRUE,A1:C1)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":29} --><\/p>\n<section class=\"emaki-custom-block emaki-custom-note\">\n<div class=\"emaki-custom note\" id=\"custom_block_32\">\n<div class=\"custom_block-content note\">\n<p>\u0644\u0627\u062d\u0638 \u0627\u0644\u0645\u0633\u0627\u0641\u0627\u062a \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0639\u0644\u0649 \u0643\u0644 \u062c\u0627\u0646\u0628 \u0645\u0646 \u0627\u0644\u0643\u0644\u0645\u0629 &#8220;\u0648&#8221; \u0641\u064a \u0627\u0644\u0635\u064a\u063a\u0629. \u0644\u0627 \u064a\u0636\u064a\u0641 Excel \u0645\u0633\u0627\u0641\u0627\u062a \u0647\u0646\u0627 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627\u060c \u0644\u0630\u0627 \u064a\u062a\u0639\u064a\u0646 \u0639\u0644\u064a\u0643 \u0625\u0636\u0627\u0641\u062a\u0647\u0627 \u064a\u062f\u0648\u064a\u064b\u0627. \u062e\u0644\u0627\u0641 \u0630\u0644\u0643\u060c \u0633\u064a\u062a\u0645 \u0636\u063a\u0637 \u0643\u0644 \u0634\u064a\u0621 \u0645\u0639\u0627 \u0648\u062a\u0628\u062f\u0648 \u063a\u064a\u0631 \u0639\u0627\u062f\u064a\u0629.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":269} --><\/section>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":269} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\" :40%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635488_968_\u0645\u0627-\u0627\u0644\u0630\u064a-\u064a\u062c\u0628-\u0639\u0644\u064a\u0643-\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647-\u0641\u064a-Excel\u061f.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure><picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"300\" loading=\"lazy\" decoding=\"async\" alt=\"\u062c\u062f\u0648\u0644 \u0628\u064a\u0627\u0646\u0627\u062a Excel \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0648\u0638\u064a\u0641\u0629 TEXTJOIN \u0644\u0625\u0636\u0627\u0641\u0629 \u0627\u0644\u0643\u0644\u0645\u0629 \" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635488_968_\u0645\u0627-\u0627\u0644\u0630\u064a-\u064a\u062c\u0628-\u0639\u0644\u064a\u0643-\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647-\u0641\u064a-Excel\u061f.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635488_968_%D9%85%D8%A7-%D8%A7%D9%84%D8%B0%D9%8A-%D9%8A%D8%AC%D8%A8-%D8%B9%D9%84%D9%8A%D9%83-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85%D9%87-%D9%81%D9%8A-Excel%D8%9F.png?resize=750%2C300&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\"> <\/picture> <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":509} --><\/p>\n<p>\u0625\u0630\u0627 \u0623\u0631\u062f\u0646\u0627 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0646\u0641\u0633 \u0627\u0644\u0635\u064a\u063a\u0629\u060c \u0648\u0644\u0643\u0646 \u0642\u0645 \u0628\u0625\u0632\u0627\u0644\u0629 \u0627\u0644\u0631\u0642\u0645 2 \u0645\u0646 \u0627\u0644\u062e\u0644\u064a\u0629 B1\u060c \u0641\u0625\u0644\u064a\u0643 \u0645\u0627 \u0633\u0646\u0631\u0627\u0647:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":604} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\" :40%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635489_210_\u0645\u0627-\u0627\u0644\u0630\u064a-\u064a\u062c\u0628-\u0639\u0644\u064a\u0643-\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647-\u0641\u064a-Excel\u061f.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure><picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"300\" loading=\"lazy\" decoding=\"async\" alt=\"\u062c\u062f\u0648\u0644 \u0628\u064a\u0627\u0646\u0627\u062a Excel \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0627\u0644\u062f\u0627\u0644\u0629 TEXTJOIN \u0645\u0639 \u0627\u0633\u062a\u0628\u0639\u0627\u062f \u0627\u0644\u0645\u0633\u0627\u0641\u0627\u062a.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635489_210_\u0645\u0627-\u0627\u0644\u0630\u064a-\u064a\u062c\u0628-\u0639\u0644\u064a\u0643-\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647-\u0641\u064a-Excel\u061f.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/1731635489_210_%D9%85%D8%A7-%D8%A7%D9%84%D8%B0%D9%8A-%D9%8A%D8%AC%D8%A8-%D8%B9%D9%84%D9%8A%D9%83-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85%D9%87-%D9%81%D9%8A-Excel%D8%9F.png?resize=750%2C300&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\"> <\/picture> <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":844} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":844,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":56,\"nextBlockCount\":163,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1007} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":900} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":0} --><\/p>\n<p>\u0647\u0630\u0627 \u0644\u0623\u0646\u0646\u0627 \u0643\u062a\u0628\u0646\u0627 <strong>\u062d\u0642\u064a\u0642\u064a<\/strong> \u0643\u0648\u0633\u064a\u0637\u0629 \u062b\u0627\u0646\u064a\u0629 \u0641\u064a \u0627\u0644\u0635\u064a\u063a\u0629 \u0644\u0625\u062e\u0628\u0627\u0631 Excel \u0628\u0627\u0633\u062a\u0628\u0639\u0627\u062f \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0641\u0627\u0631\u063a\u0629. \u0625\u0630\u0627 \u0643\u062a\u0628\u0646\u0627 <strong>\u062e\u0637\u0623 \u0634\u0646\u064a\u0639<\/strong>\u060c \u0643\u0627\u0646\u062a \u0627\u0644\u062e\u0644\u064a\u0629 B3 \u0633\u062a\u0642\u0631\u0623 &#8220;1 \u06483&#8221;.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":6,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":107} --><\/p>\n<p>\u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 TEXTJOIN \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0633\u064a\u0646\u0627\u0631\u064a\u0648\u0647\u0627\u062a:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":6,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":149} --><\/p>\n<ul>\n<li>  \u0644\u062f\u064a\u0643 \u0642\u0627\u0626\u0645\u0629 \u0628\u0639\u0646\u0627\u0648\u064a\u0646 \u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0641\u064a \u062c\u062f\u0648\u0644 \u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u062a\u0631\u064a\u062f \u0636\u0645\u0647\u0627 \u0645\u0639\u064b\u0627 &#8211; \u0645\u0641\u0635\u0648\u0644\u0629 \u0628\u0641\u0648\u0627\u0635\u0644 &#8211; \u0644\u0644\u0646\u0633\u062e \u0648\u0627\u0644\u0644\u0635\u0642 \u0641\u064a Outlook \u0644\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0645\u062c\u0645\u0639. <\/li>\n<li>  \u0644\u0642\u062f \u0642\u0645\u062a \u0628\u062a\u062c\u0645\u064a\u0639 \u0646\u062a\u0627\u0626\u062c \u0641\u0631\u064a\u0642 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 W \u0648D \u0648L\u060c \u0648\u062a\u0631\u064a\u062f \u062a\u062c\u0645\u064a\u0639 \u062c\u0645\u064a\u0639 \u0646\u062a\u0627\u0626\u062c\u0647\u0645 \u0641\u064a \u062e\u0644\u064a\u0629 \u0648\u0627\u062d\u062f\u0629\u060c \u0645\u0641\u0635\u0648\u0644\u0629 \u0628\u0634\u0631\u0637\u0627\u062a. <\/li>\n<li>  \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u0636\u0645 \u0643\u0645\u064a\u0627\u062a \u0643\u0628\u064a\u0631\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0639 \u062a\u0631\u0643 \u0645\u0633\u0627\u0641\u0627\u062a \u0628\u064a\u0646\u0647\u0627\u060c \u0623\u0648 \u062a\u0631\u064a\u062f \u062a\u0636\u0645\u064a\u0646 \u062e\u0644\u0627\u064a\u0627 \u0641\u0627\u0631\u063a\u0629 \u0641\u064a \u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u0627\u0644\u0645\u0631\u062a\u0628\u0637\u0629. <\/li>\n<\/ul>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":6,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":575} --><\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":6,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":575} --><\/p>\n<h2 id=\"in-sum-concat-vs-textjoin\"><span class=\"ez-toc-section\" id=\"%D8%A8%D8%A7%D8%AE%D8%AA%D8%B5%D8%A7%D8%B1_CONCAT_%D9%85%D9%82%D8%A7%D8%A8%D9%84_TEXTJOIN-2\"><\/span>  \u0628\u0627\u062e\u062a\u0635\u0627\u0631: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0625\u0630\u064b\u0627\u060c \u0623\u064a \u0648\u0627\u062d\u062f \u064a\u062c\u0628 \u0623\u0646 \u062a\u0633\u062a\u062e\u062f\u0645\u0647\u061f<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":6,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":604} --><\/p>\n<p>\u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u0628\u0628\u0633\u0627\u0637\u0629 \u062f\u0645\u062c \u0627\u0644\u0642\u064a\u0645 \u0645\u0646 \u0639\u062f\u0629 \u062e\u0644\u0627\u064a\u0627 \u0641\u064a \u062e\u0644\u064a\u0629 \u0648\u0627\u062d\u062f\u0629\u060c \u0641\u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u0642\u064a\u0627\u0645 \u0628\u0630\u0644\u0643 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <em>\u0643\u0648\u0646\u0643\u0627\u062a <\/em>\u062f\u0648\u0646 \u0627\u0644\u062d\u0627\u062c\u0629 \u0625\u0644\u0649 \u0627\u0644\u0642\u0644\u0642 \u0628\u0634\u0623\u0646 \u0627\u0644\u0645\u062d\u062f\u062f\u0627\u062a \u0648\u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0641\u0627\u0631\u063a\u0629. \u0641\u0642\u0637 \u0636\u0639 \u0641\u064a \u0627\u0639\u062a\u0628\u0627\u0631\u0643 \u0623\u0646\u0647 \u0645\u0627 \u0644\u0645 \u062a\u0642\u0645 \u0628\u0625\u0636\u0627\u0641\u0629 \u0645\u0633\u0627\u0641\u0627\u062a \u0623\u0648 \u0639\u0644\u0627\u0645\u0627\u062a \u062a\u0631\u0642\u064a\u0645 \u064a\u062f\u0648\u064a\u064b\u0627\u060c \u0641\u0633\u064a\u062a\u0645 \u0636\u063a\u0637 \u062c\u0645\u064a\u0639 \u0627\u0644\u0642\u064a\u0645 \u0645\u0639\u064b\u0627 \u062f\u0648\u0646 \u062a\u0639\u0631\u064a\u0641\u0627\u062a \u0648\u0627\u0636\u062d\u0629 \u0628\u064a\u0646 \u0643\u0644 \u0645\u0646\u0647\u0627. \u0642\u062f \u062a\u0641\u0636\u0644 \u0623\u064a\u0636\u064b\u0627 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 CONCAT \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u0623\u0646 \u064a\u0643\u0648\u0646 \u0644\u062f\u064a\u0643 \u0645\u062d\u062f\u062f\u0627\u062a \u0645\u062e\u062a\u0644\u0641\u0629 \u0628\u064a\u0646 \u0643\u0644 \u0642\u064a\u0645\u0629 \u0645\u062a\u0633\u0644\u0633\u0644\u0629.<\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":6,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":1025} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":7,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":7,\"nbrPlacementsScanned\":6,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":900,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><\/p>\n<p><em>\u0631\u0628\u0637 \u0646\u0635\u064a <\/em>\u0623\u0641\u0636\u0644 \u0644\u062a\u062d\u062f\u064a\u062f \u0645\u0627 \u0633\u064a\u062a\u0645 \u0648\u0636\u0639\u0647 \u0628\u064a\u0646 \u0643\u0644 \u0642\u064a\u0645\u0629 \u0645\u0631\u062a\u0628\u0637\u0629\u060c \u0645\u062b\u0644 \u0627\u0644\u0643\u0644\u0645\u0627\u062a \u0623\u0648 \u0627\u0644\u0645\u0633\u0627\u0641\u0627\u062a \u0623\u0648 \u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u062a\u0631\u0642\u064a\u0645. \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 CONCAT \u0648\u0625\u062f\u0631\u0627\u062c \u0641\u0627\u0635\u0644\u0629 \u064a\u062f\u0648\u064a\u064b\u0627\u060c \u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u0628\u064a\u0646 \u0643\u0644 \u0642\u064a\u0645\u0629\u060c \u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u0642\u064a\u0627\u0645 \u0628\u0630\u0644\u0643 \u0628\u0634\u0643\u0644 \u0623\u0643\u062b\u0631 \u0643\u0641\u0627\u0621\u0629 \u0639\u0646 \u0637\u0631\u064a\u0642 \u0625\u0636\u0627\u0641\u0629 \u0645\u062d\u062f\u062f \u0643\u0648\u0633\u064a\u0637\u0629 \u0623\u0648\u0644\u0649 \u062f\u0627\u062e\u0644 \u0627\u0644\u0623\u0642\u0648\u0627\u0633. \u064a\u0639\u062f \u0647\u0630\u0627 \u0645\u0641\u064a\u062f\u064b\u0627 \u0628\u0634\u0643\u0644 \u062e\u0627\u0635 \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0643\u0645\u064a\u0627\u062a \u0643\u0628\u064a\u0631\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a. \u062a\u0630\u0643\u0631 \u0641\u0642\u0637 \u0623\u0646\u0647 \u064a\u0645\u0643\u0646\u0643 \u062a\u062d\u062f\u064a\u062f \u0645\u062d\u062f\u062f \u0648\u0627\u062d\u062f \u0641\u0642\u0637 \u0639\u0646\u062f \u0627\u0633\u062a\u062e\u062f\u0627\u0645 TEXTJOIN\u060c \u0645\u0645\u0627 \u064a\u0639\u0646\u064a \u0623\u0646\u0643 \u0633\u062a\u0646\u062a\u0647\u064a \u0628\u0646\u0641\u0633 \u0627\u0644\u0642\u064a\u0645\u0629 \u0623\u0648 \u0627\u0644\u0631\u0645\u0632 \u0627\u0644\u0645\u0648\u0636\u0648\u0639 \u0628\u064a\u0646 \u0643\u0644 \u0639\u0646\u0635\u0631 \u0645\u062a\u0635\u0644 \u0645\u0639\u064b\u0627.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":7,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":7,\"nbrPlacementsScanned\":7,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":542} --><\/p>\n<hr\/>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":7,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":7,\"nbrPlacementsScanned\":7,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":542} --><\/p>\n<p>\u0628\u0627\u0644\u0625\u0636\u0627\u0641\u0629 \u0625\u0644\u0649 \u062a\u0644\u0643 \u0627\u0644\u0645\u0630\u0643\u0648\u0631\u0629 \u0623\u0639\u0644\u0627\u0647\u060c \u0647\u0646\u0627\u0643 \u0637\u0631\u0642 \u0623\u062e\u0631\u0649 \u0644\u0631\u0628\u0637 \u0627\u0644\u0642\u064a\u0645 \u0645\u0639\u064b\u0627 \u0641\u064a Excel. \u0623\u0648\u0644\u0627\u064b\u060c \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0631\u0645\u0632 \u0639\u0644\u0627\u0645\u0629 \u0627\u0644\u0639\u0637\u0641 (&#038;) \u0628\u064a\u0646 \u0645\u0631\u0627\u062c\u0639 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0641\u064a \u0627\u0644\u0635\u064a\u063a\u0629. \u0648\u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0630\u0644\u0643\u060c \u062a\u0642\u0648\u0645 \u0623\u062f\u0627\u0629 \u0627\u0644\u062a\u0639\u0628\u0626\u0629 \u0627\u0644\u0633\u0631\u064a\u0639\u0629 \u0641\u064a Excel (\u0627\u062e\u062a\u0635\u0627\u0631 \u0644\u0648\u062d\u0629 \u0627\u0644\u0645\u0641\u0627\u062a\u064a\u062d: Ctrl+E) \u0628\u062a\u062d\u062f\u064a\u062f \u0627\u0644\u0623\u0646\u0645\u0627\u0637 \u0648\u062a\u0637\u0628\u064a\u0642\u0647\u0627 \u0639\u0644\u0649 \u0628\u0642\u064a\u0629 \u0627\u0644\u0633\u0644\u0633\u0644\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":7,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":7,\"nbrPlacementsScanned\":7,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":842} -->\n <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062a\u0645\u062a \u0625\u0636\u0627\u0641\u0629 CONCAT \u0648TEXTJOIN \u0625\u0644\u0649 Excel \u0641\u064a \u0639\u0627\u0645 2019\u060c \u0644\u0630\u0644\u0643 \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0633\u062a\u062e\u062f\u0645 \u0625\u0635\u062f\u0627\u0631\u064b\u0627 \u0623\u0642\u062f\u0645\u060c \u0641\u0642\u062f \u0644\u0627 \u062a\u062a\u0645\u0643\u0646 \u0645\u0646 \u0627\u0644\u0648\u0635\u0648\u0644 \u0625\u0644\u0649 \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u0627\u0626\u0641. \u0628\u0627\u062e\u062a\u0635\u0627\u0631: CONCAT \u0645\u0642\u0627\u0628\u0644 TEXTJOIN \u0643\u0644\u0627\u0647\u0645\u0627 \u064a\u062c\u0645\u0639 \u0627\u0644\u0646\u0635 \u0645\u0646 \u062e\u0644\u0627\u064a\u0627 \u0645\u062a\u0639\u062f\u062f\u0629 \u0641\u064a \u062e\u0644\u064a\u0629 \u0648\u0627\u062d\u062f\u0629. \u0648\u0641\u0642 \u0642\u0627\u0645\u0648\u0633 \u0643\u0627\u0645\u0628\u0631\u064a\u062f\u062c\u060c \u0627\u0644\u0641\u0639\u0644 \u0644\u062a\u0633\u0644\u0633\u0644 \u064a\u0639\u0646\u064a &#8220;\u062c\u0645\u0639 \u0627\u0644\u0623\u0634\u064a\u0627\u0621 \u0645\u0639\u064b\u0627 \u0643\u0633\u0644\u0633\u0644\u0629 \u0645\u062a\u0635\u0644\u0629&#8221;\u060c \u0648CONCAT \u062a\u0642\u0648\u0645 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0628\u0630\u0644\u0643 \u0628\u0627\u0644\u0636\u0628\u0637 \u0639\u0646 \u0637\u0631\u064a\u0642 \u062c\u0645\u0639 &#8230; <a title=\"\u0645\u0627 \u0627\u0644\u0630\u064a \u064a\u062c\u0628 \u0639\u0644\u064a\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647 \u0641\u064a Excel\u061f\" class=\"read-more\" href=\"https:\/\/goodwriterz.com\/site\/%d9%85%d8%a7-%d8%a7%d9%84%d8%b0%d9%8a-%d9%8a%d8%ac%d8%a8-%d8%b9%d9%84%d9%8a%d9%83-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85%d9%87-%d9%81%d9%8a-excel%d8%9f\/\" aria-label=\"Read more about \u0645\u0627 \u0627\u0644\u0630\u064a \u064a\u062c\u0628 \u0639\u0644\u064a\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647 \u0641\u064a Excel\u061f\">\u0625\u0642\u0631\u0623 \u0627\u0644\u0645\u0632\u064a\u062f<\/a><\/p>\n","protected":false},"author":1,"featured_media":74122,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-74121","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/11\/%D9%85%D8%A7-%D8%A7%D9%84%D8%B0%D9%8A-%D9%8A%D8%AC%D8%A8-%D8%B9%D9%84%D9%8A%D9%83-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85%D9%87-%D9%81%D9%8A-Excel%D8%9F.jpeg?fit=2400%2C1600&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/74121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/comments?post=74121"}],"version-history":[{"count":1,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/74121\/revisions"}],"predecessor-version":[{"id":74123,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/74121\/revisions\/74123"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media\/74122"}],"wp:attachment":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media?parent=74121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/categories?post=74121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/tags?post=74121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}