{"id":62050,"date":"2024-09-09T12:04:03","date_gmt":"2024-09-09T12:04:03","guid":{"rendered":"https:\/\/goodwriterz.com\/site\/?p=62050"},"modified":"2024-09-09T12:04:03","modified_gmt":"2024-09-09T12:04:03","slug":"%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d9%82%d8%b3%d9%8a%d9%85-%d9%88%d8%a7%d8%b3%d8%aa%d8%ae%d8%b1%d8%a7%d8%ac-%d8%a7%d9%84%d9%86%d8%b5-%d9%81%d9%8a-microsoft-excel","status":"publish","type":"post","link":"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d9%82%d8%b3%d9%8a%d9%85-%d9%88%d8%a7%d8%b3%d8%aa%d8%ae%d8%b1%d8%a7%d8%ac-%d8%a7%d9%84%d9%86%d8%b5-%d9%81%d9%8a-microsoft-excel\/","title":{"rendered":"\u0643\u064a\u0641\u064a\u0629 \u062a\u0642\u0633\u064a\u0645 \u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0644\u0646\u0635 \u0641\u064a Microsoft Excel"},"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%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d9%82%d8%b3%d9%8a%d9%85-%d9%88%d8%a7%d8%b3%d8%aa%d8%ae%d8%b1%d8%a7%d8%ac-%d8%a7%d9%84%d9%86%d8%b5-%d9%81%d9%8a-microsoft-excel\/#%D8%AF%D8%A7%D9%84%D8%A9_TEXTBEFORE\" title=\"\u062f\u0627\u0644\u0629 TEXTBEFORE\">\u062f\u0627\u0644\u0629 TEXTBEFORE<\/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%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d9%82%d8%b3%d9%8a%d9%85-%d9%88%d8%a7%d8%b3%d8%aa%d8%ae%d8%b1%d8%a7%d8%ac-%d8%a7%d9%84%d9%86%d8%b5-%d9%81%d9%8a-microsoft-excel\/#%D9%88%D8%B8%D9%8A%D9%81%D8%A9_TEXTAFTER\" title=\"\u0648\u0638\u064a\u0641\u0629 TEXTAFTER\">\u0648\u0638\u064a\u0641\u0629 TEXTAFTER<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d9%82%d8%b3%d9%8a%d9%85-%d9%88%d8%a7%d8%b3%d8%aa%d8%ae%d8%b1%d8%a7%d8%ac-%d8%a7%d9%84%d9%86%d8%b5-%d9%81%d9%8a-microsoft-excel\/#%D8%AF%D8%A7%D9%84%D8%A9_TEXTSPLIT\" title=\"\u062f\u0627\u0644\u0629 TEXTSPLIT\">\u062f\u0627\u0644\u0629 TEXTSPLIT<\/a><\/li><\/ul><\/nav><\/div>\n<div>\n<p>  \u064a\u0642\u062f\u0645 Microsoft Excel \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0644\u0644\u0639\u0645\u0644 \u0645\u0639 \u0627\u0644\u0646\u0635. \u0639\u0646\u062f\u0645\u0627 \u062a\u0631\u064a\u062f \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u062c\u0632\u0621 \u0645\u0646 \u0633\u0644\u0633\u0644\u0629 \u0646\u0635\u064a\u0629 \u0623\u0648 \u062a\u0642\u0633\u064a\u0645 \u0633\u0644\u0633\u0644\u0629 \u0625\u0644\u0649 \u0635\u0641\u0648\u0641 \u0623\u0648 \u0623\u0639\u0645\u062f\u0629\u060c \u0641\u0647\u0646\u0627\u0643 \u062b\u0644\u0627\u062b \u0648\u0638\u0627\u0626\u0641 \u0645\u0639\u064a\u0646\u0629 \u062a\u0624\u062f\u064a \u0647\u0630\u0647 \u0627\u0644\u0645\u0647\u0645\u0629. <\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":0,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":0,\"nbrPlacementsScanned\":0,\"ruleCount\":200,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":213} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":0,\"ruleCount\":200,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":200,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><br \/>\n<!-- No winning ad found for zone: below first paragraph! --><br \/>\n<!-- No winning ad found for zone: mid intro! --><\/p>\n<p>  \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 TEXTBEFORE \u0648TEXTAFTER\u060c \u064a\u0645\u0643\u0646\u0643 \u0633\u062d\u0628 \u0627\u0644\u0646\u0635 \u0642\u0628\u0644 \u0623\u0648 \u0628\u0639\u062f \u0643\u0644\u0645\u0629 \u0623\u0648 \u062d\u0631\u0641 \u0645\u0639\u064a\u0646. \u0648\u0647\u0630\u0627 \u064a\u062c\u0639\u0644 \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0623\u0643\u062b\u0631 \u0645\u0631\u0648\u0646\u0629 \u0645\u0646 \u0648\u0638\u0627\u0626\u0641 LEFT \u0648RIGHT \u0648MID \u0627\u0644\u062a\u064a \u0642\u062f \u062a\u0633\u062a\u062e\u062f\u0645\u0647\u0627. \u0644\u062a\u0642\u0633\u064a\u0645 \u0633\u0644\u0633\u0644\u0629 \u0625\u0644\u0649 \u062e\u0644\u0627\u064a\u0627 \u0645\u062e\u062a\u0644\u0641\u0629\u060c \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 TEXTSPLIT. <\/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\":266} --><\/p>\n<section class=\"emaki-custom-block emaki-custom-note\">\n<div class=\"emaki-custom note\" id=\"custom_block_2\">\n<div class=\"custom_block-content note\">\n<p>  \u062a\u064f\u0639\u062f \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0627\u0644\u062b\u0644\u0627\u062b \u062c\u062f\u064a\u062f\u0629 \u0641\u064a Excel \u0627\u0639\u062a\u0628\u0627\u0631\u064b\u0627 \u0645\u0646 \u0623\u063a\u0633\u0637\u0633 2022. \u0648\u0633\u064a\u062a\u0645 \u0637\u0631\u062d\u0647\u0627 \u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a Office Insider \u062b\u0645 \u0644\u062c\u0645\u064a\u0639 \u0645\u0633\u062a\u062e\u062f\u0645\u064a Excel \u0628\u0645\u0631\u0648\u0631 \u0627\u0644\u0648\u0642\u062a. <\/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\":506} --><\/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\":506} --><br \/>\n<!-- No winning ad found for zone: native in content! --><\/p>\n<h2 id=\"the-textbefore-function\"><span class=\"ez-toc-section\" id=\"%D8%AF%D8%A7%D9%84%D8%A9_TEXTBEFORE\"><\/span>  \u062f\u0627\u0644\u0629 TEXTBEFORE <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>  \u0628\u0646\u0627\u0621 \u0627\u0644\u062c\u0645\u0644\u0629 \u0644\u0644\u0648\u0638\u064a\u0641\u0629 \u0647\u0648 <\/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\":538} --><\/p>\n<pre><code class=\"hljs \">TEXTBEFORE(text, delimiter, instance, match_mode, match_end, if_not_found)<\/code> <\/pre>\n<p>  . \u0627\u0644\u062d\u062c\u062c\u062a\u0627\u0646 \u0627\u0644\u0623\u0648\u0644\u064a\u062a\u0627\u0646 \u0645\u0637\u0644\u0648\u0628\u062a\u0627\u0646 \u0645\u0639 <code>text<\/code> \u0625\u0645\u0627 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0627\u0644\u0646\u0635 \u0627\u0644\u0641\u0639\u0644\u064a \u0623\u0648 \u0645\u0631\u062c\u0639 \u062e\u0644\u064a\u0629 \u0648 <code>delimiter<\/code> \u0643\u0648\u0646\u0647\u0627 \u0627\u0644\u0646\u0642\u0637\u0629 \u0627\u0644\u062a\u064a \u062a\u0631\u064a\u062f \u0623\u0646 \u064a\u0635\u0644 \u0625\u0644\u064a\u0647\u0627 \u0627\u0644\u0646\u0635. <\/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\":702} --><\/p>\n<p>  \u0641\u064a\u0645\u0627 \u064a\u0644\u064a \u0623\u0648\u0635\u0627\u0641 \u0644\u0644\u062d\u062c\u062c \u0627\u0644\u0627\u062e\u062a\u064a\u0627\u0631\u064a\u0629 \u0627\u0644\u062b\u0644\u0627\u062b\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\":758} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":758,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":142,\"nextBlockCount\":420,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1178} --><\/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<ul>\n<li><strong>\u0645\u062b\u0627\u0644<\/strong>:\u0627\u0633\u062a\u062e\u062f\u0645 \u0647\u0630\u0647 \u0627\u0644\u062d\u062c\u0629 \u0625\u0630\u0627 \u0643\u0627\u0646 \u0647\u0646\u0627\u0643 \u0623\u0643\u062b\u0631 \u0645\u0646 \u062d\u062f\u0648\u062b \u0644\u0640 <code>delimiter<\/code> \u0641\u064a \u0627\u0644\u0633\u0644\u0633\u0644\u0629 \u0648\u062a\u0631\u064a\u062f \u0648\u0627\u062d\u062f\u0629 \u0645\u0639\u064a\u0646\u0629. <\/li>\n<li><strong>\u0648\u0636\u0639 \u0627\u0644\u0645\u0628\u0627\u0631\u0627\u0629<\/strong>:\u0623\u062f\u062e\u0644 0 \u0644\u062d\u0627\u0644\u0629 \u0627\u0644\u0623\u062d\u0631\u0641 \u0627\u0644\u062d\u0633\u0627\u0633\u0629 \u0623\u0648 1 \u0644\u0639\u062f\u0645 \u062d\u0633\u0627\u0633\u064a\u0629 \u0627\u0644\u062d\u0627\u0644\u0629. \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 \u0647\u064a 0. <\/li>\n<li><strong>\u0646\u0647\u0627\u064a\u0629 \u0627\u0644\u0645\u0628\u0627\u0631\u0627\u0629<\/strong>:\u0623\u062f\u062e\u0644 0 \u0644\u0639\u062f\u0645 \u0645\u0637\u0627\u0628\u0642\u0629 \u0627\u0644\u0641\u0627\u0635\u0644 \u0645\u0639 \u0646\u0647\u0627\u064a\u0629 \u0627\u0644\u0646\u0635 \u06481 \u0644\u0645\u0637\u0627\u0628\u0642\u062a\u0647. \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 \u0647\u064a 1. <\/li>\n<li><strong>\u0625\u0630\u0627 \u0644\u0645 \u064a\u062a\u0645 \u0627\u0644\u0639\u062b\u0648\u0631 \u0639\u0644\u064a\u0647<\/strong>:\u0627\u0633\u062a\u062e\u062f\u0645 \u0647\u0630\u0647 \u0627\u0644\u062d\u062c\u0629 \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0641\u0636\u0644 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0646\u062a\u064a\u062c\u0629 \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u062e\u0637\u0623 \u0644\u0644\u0642\u064a\u0645 \u063a\u064a\u0631 \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629. <\/li>\n<\/ul>\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\":278} --><\/p>\n<p>  \u0627\u0644\u0622\u0646 \u0628\u0639\u062f \u0623\u0646 \u062a\u0639\u0631\u0641\u062a \u0639\u0644\u0649 \u0627\u0644\u062d\u062c\u062c\u060c \u062f\u0639\u0646\u0627 \u0646\u0644\u0642\u064a \u0646\u0638\u0631\u0629 \u0639\u0644\u0649 \u0628\u0639\u0636 \u0623\u0645\u062b\u0644\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0627\u062a TEXTBEFORE. <\/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\":364} --><\/p>\n<p>  \u0641\u064a \u0647\u0630\u0627 \u0627\u0644\u0645\u062b\u0627\u0644 \u0627\u0644\u0623\u0648\u0644\u060c \u0633\u0646\u0633\u062a\u062e\u0631\u062c \u0643\u0644 \u0627\u0644\u0646\u0635 \u0642\u0628\u0644 \u0627\u0644\u0643\u0644\u0645\u0629 &#8220;\u0645\u0646&#8221; \u0641\u064a \u0627\u0644\u062e\u0644\u064a\u0629 A2 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a\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\":479} --><\/p>\n<pre>=TEXTBEFORE(A2,\"from\")<\/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\":513} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"580\" height=\"220\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 TEXTBEFORE \u0644\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0623\u0633\u0627\u0633\u064a\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=580%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\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\":753} --><\/p>\n<p>  \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629\u060c \u0633\u0648\u0641 \u0646\u0633\u062a\u062e\u0631\u062c \u0643\u0644 \u0627\u0644\u0646\u0635 \u0642\u0628\u0644 \u0627\u0644\u0645\u062b\u064a\u0644 \u0627\u0644\u062b\u0627\u0646\u064a \u0644\u0644\u0643\u0644\u0645\u0629 &#8220;\u0646\u0635&#8221;. <\/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\":863} --><\/p>\n<pre>=TEXTBEFORE(A2,\"text\",2)<\/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\":899} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":899,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":1,\"nextBlockCount\":240,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1139} --><\/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\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"580\" height=\"220\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 TEXTBEFORE \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u062b\u064a\u0644\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883439_861_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883439_861_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=580%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/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\":239} --><\/p>\n<p>  \u0644\u0645\u062b\u0627\u0644 \u0622\u062e\u0631\u060c \u0633\u0648\u0641 \u0646\u0633\u062a\u062e\u062f\u0645 <code>match_mode<\/code> \u062d\u062c\u0629 \u0644\u0645\u0637\u0627\u0628\u0642\u0629 \u062d\u0633\u0627\u0633\u0629 \u0644\u062d\u0627\u0644\u0629 \u0627\u0644\u0623\u062d\u0631\u0641. <\/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\":328} --><\/p>\n<pre>=TEXTBEFORE(A2,\"TEXT\",,0)<\/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\":365} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"620\" height=\"220\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 TEXTBEFORE \u062a\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0623\u062d\u0631\u0641 \u0627\u0644\u062d\u0633\u0627\u0633\u0629 \u0644\u062d\u0627\u0644\u0629 \u0627\u0644\u0623\u062d\u0631\u0641\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883439_750_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883439_750_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=620%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/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\":605} --><\/p>\n<p> <span class=\"related-single\">\u0630\u0627\u062a \u0635\u0644\u0629: 13 \u0648\u0638\u064a\u0641\u0629 \u0623\u0633\u0627\u0633\u064a\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c Excel \u0644\u0625\u062f\u062e\u0627\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/span> <\/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\":659} --><\/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\":659} --><\/p>\n<h2 id=\"the-textafter-function\"><span class=\"ez-toc-section\" id=\"%D9%88%D8%B8%D9%8A%D9%81%D8%A9_TEXTAFTER\"><\/span>  \u0648\u0638\u064a\u0641\u0629 TEXTAFTER <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>  TEXTAFTER \u0647\u0648 \u0639\u0643\u0633 TEXTBEFORE \u062a\u0645\u0627\u0645\u064b\u0627. \u0628\u0646\u0627\u0621 \u0627\u0644\u062c\u0645\u0644\u0629 \u0644\u0644\u0648\u0638\u064a\u0641\u0629 \u0647\u0648 <code>TEXTAFTER(text, delimiter, instance, match_mode, match_end, if_not_found)<\/code>. <\/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\":813} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":813,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":87,\"nextBlockCount\":183,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":996} --><\/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<p>  \u0645\u062b\u0644 \u0646\u0638\u064a\u0631\u0647\u060c \u0641\u0625\u0646 \u0627\u0644\u062d\u062c\u062a\u064a\u0646 \u0627\u0644\u0623\u0648\u0644\u064a\u064a\u0646 \u0645\u0637\u0644\u0648\u0628\u062a\u0627\u0646 \u0645\u0639 <code>text<\/code> \u0625\u0645\u0627 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0627\u0644\u0646\u0635 \u0627\u0644\u0641\u0639\u0644\u064a \u0623\u0648 \u0645\u0631\u062c\u0639 \u062e\u0644\u064a\u0629 \u0648 <code>delimiter<\/code> \u0643\u0648\u0646\u0647\u0627 \u0627\u0644\u0646\u0642\u0637\u0629 \u0627\u0644\u062a\u064a \u062a\u0631\u064a\u062f \u0627\u0644\u0646\u0635 \u0628\u0639\u062f\u0647\u0627. <\/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\":96} --><\/p>\n<p>  \u062a\u0639\u0645\u0644 \u0627\u0644\u0648\u0633\u0627\u0626\u0637 \u0627\u0644\u0627\u062e\u062a\u064a\u0627\u0631\u064a\u0629 \u0627\u0644\u062b\u0644\u0627\u062b\u0629 \u0627\u0644\u0645\u0648\u0636\u062d\u0629 \u0623\u0639\u0644\u0627\u0647 \u0623\u064a\u0636\u064b\u0627 \u0628\u0646\u0641\u0633 \u0637\u0631\u064a\u0642\u0629 \u0648\u0638\u064a\u0641\u0629 TEXTBEFORE. <\/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\":189} --><\/p>\n<p>  \u0641\u064a \u0647\u0630\u0627 \u0627\u0644\u0645\u062b\u0627\u0644 \u0627\u0644\u0623\u0648\u0644\u060c \u0633\u0648\u0641 \u0646\u0642\u0648\u0645 \u0628\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0643\u0644 \u0627\u0644\u0646\u0635 \u0628\u0639\u062f \u0627\u0644\u0643\u0644\u0645\u0629 &#8220;\u0645\u0646&#8221; \u0641\u064a \u0627\u0644\u062e\u0644\u064a\u0629 A2 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a\u0629: <\/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\":303} --><\/p>\n<pre>=TEXTAFTER(A2,\"from\")<\/pre>\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\":336} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"580\" height=\"220\" loading=\"lazy\" alt=\"\u0648\u0638\u064a\u0641\u0629 TEXTAFTER \u0644\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0623\u0633\u0627\u0633\u064a\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883439_836_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883439_836_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=580%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\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\":576} --><\/p>\n<p>  \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629\u060c \u0633\u0648\u0641 \u0646\u0633\u062a\u062e\u0631\u062c \u0643\u0644 \u0627\u0644\u0646\u0635 \u0628\u0639\u062f \u0627\u0644\u0645\u062b\u064a\u0644 \u0627\u0644\u062b\u0627\u0646\u064a \u0644\u0644\u0643\u0644\u0645\u0629 &#8220;\u0646\u0635&#8221;. <\/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\":685} --><\/p>\n<pre>=TEXTAFTER(A2,\"text\",2)<\/pre>\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\":720} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"580\" height=\"220\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 TEXTAFTER \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u062b\u064a\u0644\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883439_90_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883439_90_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=580%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\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\":960} --><!-- 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<p>  \u0648\u0623\u062e\u064a\u0631\u064b\u0627\u060c \u0633\u0648\u0641 \u0646\u0633\u062a\u062e\u062f\u0645 <code>match_mode<\/code> \u062d\u062c\u0629 \u0644\u0645\u0637\u0627\u0628\u0642\u0629 \u062d\u0633\u0627\u0633\u0629 \u0644\u062d\u0627\u0644\u0629 \u0627\u0644\u0623\u062d\u0631\u0641. <\/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\":80} --><\/p>\n<pre>=TEXTAFTER(A2,\"TEXT\",,0)<\/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\":116} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"620\" height=\"220\" loading=\"lazy\" alt=\"\u062f\u0627\u0644\u0629 TEXTAFTER \u062a\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0623\u062d\u0631\u0641 \u0627\u0644\u062d\u0633\u0627\u0633\u0629 \u0644\u062d\u0627\u0644\u0629 \u0627\u0644\u0623\u062d\u0631\u0641\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883440_208_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883440_208_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=620%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/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\":356} --><\/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\":356} --><\/p>\n<h2 id=\"the-textsplit-function\"><span class=\"ez-toc-section\" id=\"%D8%AF%D8%A7%D9%84%D8%A9_TEXTSPLIT\"><\/span>  \u062f\u0627\u0644\u0629 TEXTSPLIT <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>  \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0648\u0638\u064a\u0641\u0629 TEXTSPLIT\u060c \u064a\u0645\u0643\u0646\u0643 \u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u0646\u0635 \u0625\u0644\u0649 \u062e\u0644\u0627\u064a\u0627 \u0641\u064a \u0635\u0641 \u0623\u0648 \u0639\u0645\u0648\u062f \u0627\u0633\u062a\u0646\u0627\u062f\u064b\u0627 \u0625\u0644\u0649 \u0627\u0644\u0641\u0627\u0635\u0644\u060c \u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u0645\u0633\u0627\u0641\u0629 \u0623\u0648 \u0646\u0642\u0637\u0629. <\/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\":494} --><\/p>\n<p> <span class=\"related-single\">\u0630\u0627\u062a \u0635\u0644\u0629: \u0643\u064a\u0641\u064a\u0629 \u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 \u0623\u0639\u0645\u062f\u0629 \u0645\u062a\u0639\u062f\u062f\u0629 \u0641\u064a Excel<\/span> <\/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\":553} --><\/p>\n<p>  \u0628\u0646\u0627\u0621 \u0627\u0644\u062c\u0645\u0644\u0629 \u0647\u0648 <code>TEXTSPLIT(text, column_delimiter, row_delimiter, ignore, match_mode, pad_with)<\/code> \u062d\u064a\u062b \u062a\u0643\u0648\u0646 \u0627\u0644\u062d\u062c\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 \u0645\u0637\u0644\u0648\u0628\u0629 \u0648\u064a\u0645\u0643\u0646 \u0623\u0646 \u062a\u0643\u0648\u0646 \u0646\u0635\u064b\u0627 \u0641\u0639\u0644\u064a\u064b\u0627 \u0623\u0648 \u0645\u0631\u062c\u0639 \u062e\u0644\u064a\u0629. \u0628\u0634\u0643\u0644 \u0627\u0641\u062a\u0631\u0627\u0636\u064a\u060c \u062a\u0642\u0633\u0645 \u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u0646\u0635 \u0625\u0644\u0649 \u0623\u0639\u0645\u062f\u0629\u060c \u0648\u0644\u0643\u0646 \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u0641\u0648\u0641 \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0630\u0644\u0643 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <code>row_delimiter<\/code> \u062f\u0639\u0648\u0649. <\/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\":844} --><\/p>\n<p>  \u0648\u0641\u064a\u0645\u0627 \u064a\u0644\u064a \u0623\u0648\u0635\u0627\u0641 \u0644\u0644\u062d\u062c\u062c \u0627\u0644\u0645\u062a\u0628\u0642\u064a\u0629: <\/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\":895} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":895,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":5,\"nextBlockCount\":266,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1161} --><\/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<ul>\n<li><strong>\u064a\u062a\u062c\u0627\u0647\u0644<\/strong>:\u0623\u062f\u062e\u0644 FALSE \u0644\u0625\u0646\u0634\u0627\u0621 \u062e\u0644\u064a\u0629 \u0641\u0627\u0631\u063a\u0629 \u0639\u0646\u062f\u0645\u0627 \u064a\u0643\u0648\u0646 \u0647\u0646\u0627\u0643 \u0641\u0627\u0635\u0644\u0627\u0646 \u0645\u062a\u062a\u0627\u0644\u064a\u0627\u0646. \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 \u0647\u064a TRUE. <\/li>\n<li><strong>\u0648\u0636\u0639 \u0627\u0644\u0645\u0628\u0627\u0631\u0627\u0629<\/strong>:\u064a\u0628\u062d\u062b \u0627\u0644\u0641\u0627\u0635\u0644 \u0639\u0646 \u062a\u0637\u0627\u0628\u0642 \u0645\u0639 \u0627\u0644\u0648\u0636\u0639 \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a \u062d\u0633\u0627\u0633 \u0644\u062d\u0627\u0644\u0629 \u0627\u0644\u0623\u062d\u0631\u0641. <\/li>\n<li><strong>\u0648\u0633\u0627\u062f\u0629_\u0645\u0639<\/strong>:\u0644\u062a\u0639\u0628\u0626\u0629 \u0627\u0644\u0646\u062a\u064a\u062c\u0629\u060c \u0623\u062f\u062e\u0644 \u0642\u064a\u0645\u0629. \u0648\u0625\u0644\u0627\u060c \u0641\u0633\u064a\u062a\u0645 \u0639\u0631\u0636 \u0627\u0644\u062e\u0637\u0623 #N\/A. <\/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\":261} --><\/p>\n<p>  \u0641\u064a \u0647\u0630\u0627 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u0633\u0646\u0642\u0648\u0645 \u0628\u062a\u0642\u0633\u064a\u0645 \u0633\u0644\u0633\u0644\u0629 \u0627\u0644\u0646\u0635 \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a \u0627\u0644\u062e\u0644\u064a\u0629 A2 \u0639\u0628\u0631 \u0627\u0644\u0623\u0639\u0645\u062f\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0633\u0627\u0641\u0629 \u0643\u0640 <code>column_delimiter<\/code> \u0628\u064a\u0646 \u0639\u0644\u0627\u0645\u062a\u064a \u0627\u0644\u0627\u0642\u062a\u0628\u0627\u0633. \u0625\u0644\u064a\u0643 \u0627\u0644\u0635\u064a\u063a\u0629: <\/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\":409} --><\/p>\n<pre>=TEXTSPLIT(A2,\" \")<\/pre>\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\":439} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"650\" height=\"105\" loading=\"lazy\" alt=\"\u0648\u0638\u064a\u0641\u0629 TEXTSPLIT \u0639\u0628\u0631 \u0627\u0644\u0623\u0639\u0645\u062f\u0629\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883440_521_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883440_521_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=650%2C105&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\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\":679} --><\/p>\n<p>  \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u0633\u0644\u0633\u0644\u0629 \u0639\u0628\u0631 \u0627\u0644\u0623\u0639\u0645\u062f\u0629\u060c \u0633\u0646\u0642\u0648\u0645 \u0628\u062a\u0642\u0633\u064a\u0645\u0647\u0627 \u0639\u0628\u0631 \u0627\u0644\u0635\u0641\u0648\u0641 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0633\u0627\u0641\u0629 \u0643\u0640 <code>row_delimiter<\/code> \u0645\u0639 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a\u0629: <\/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\":813} --><\/p>\n<pre>=TEXTSPLIT(A2,,\" \")<\/pre>\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\":844} --><\/p>\n<p>  \u0644\u0627\u062d\u0638 \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a\u0629\u060c \u0646\u062a\u0631\u0643 <code>column_delimiter<\/code> \u0627\u0644\u062d\u062c\u0629 \u0641\u0627\u0631\u063a\u0629 \u0648\u0627\u0633\u062a\u062e\u062f\u0645 \u0641\u0642\u0637 <code>row_delimiter<\/code>. <\/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\":946} --><!-- 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<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"539\" height=\"500\" loading=\"lazy\" alt=\"\u0648\u0638\u064a\u0641\u0629 TEXTSPLIT \u0639\u0628\u0631 \u0627\u0644\u0635\u0641\u0648\u0641\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883440_84_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883440_84_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=539%2C500&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\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\":240} --><\/p>\n<p>  \u0628\u0627\u0644\u0646\u0633\u0628\u0629 \u0644\u0644\u0645\u062b\u0627\u0644 \u0627\u0644\u062a\u0627\u0644\u064a\u060c \u0633\u0646\u0642\u0648\u0645 \u0628\u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0641\u0642\u0637 \u0628\u0639\u062f \u0627\u0644\u0641\u0627\u0635\u0644\u0629 \u0627\u0644\u0645\u0646\u0642\u0648\u0637\u0629 \u0625\u0644\u0649 \u0639\u0645\u0648\u062f \u0622\u062e\u0631: <\/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\":326} --><\/p>\n<pre>=TEXTSPLIT(A2,\";\")<\/pre>\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\":356} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"650\" height=\"213\" loading=\"lazy\" alt=\"\u0648\u0638\u064a\u0641\u0629 TEXTSPLIT \u0639\u0628\u0631 \u0627\u0644\u0623\u0639\u0645\u062f\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0641\u0627\u0635\u0644 \u0648\u0627\u062d\u062f\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883441_90_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883441_90_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=650%2C213&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\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\":596} --><\/p>\n<p>  \u0628\u0639\u062f \u0630\u0644\u0643\u060c \u0633\u0646\u0642\u0648\u0645 \u0628\u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0641\u0642\u0637 \u0628\u0639\u062f \u0627\u0644\u0641\u0627\u0635\u0644\u0629 \u0627\u0644\u0645\u0646\u0642\u0648\u0637\u0629 \u0625\u0644\u0649 \u0635\u0641 \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0639\u0645\u0648\u062f: <\/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\":676} --><\/p>\n<pre>=TEXTSPLIT(A2,,\";\")<\/pre>\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\":707} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"650\" height=\"240\" loading=\"lazy\" alt=\"\u0648\u0638\u064a\u0641\u0629 TEXTSPLIT \u0639\u0628\u0631 \u0627\u0644\u0635\u0641\u0648\u0641 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0641\u0627\u0635\u0644 \u0648\u0627\u062d\u062f\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883441_882_\u0643\u064a\u0641\u064a\u0629-\u062a\u0642\u0633\u064a\u0645-\u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c-\u0627\u0644\u0646\u0635-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1725883441_882_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.png?resize=650%2C240&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":7,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":7,\"nbrPlacementsScanned\":7,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":947} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":8,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":8,\"nbrPlacementsScanned\":7,\"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>  \u062a\u0639\u062f \u062f\u0627\u0644\u0629 TEXTSPLIT \u062f\u0627\u0644\u0629 \u0642\u0648\u064a\u0629. \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0645\u062b\u0644\u0629 \u0623\u0643\u062b\u0631 \u062a\u0639\u0642\u064a\u062f\u064b\u0627 \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0648\u0633\u0627\u0626\u0637 \u0627\u0644\u0627\u062e\u062a\u064a\u0627\u0631\u064a\u0629\u060c \u0641\u0642\u0645 \u0628\u0632\u064a\u0627\u0631\u0629 <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7\">\u0635\u0641\u062d\u0629 \u062f\u0639\u0645 Microsoft \u0644\u0648\u0638\u064a\u0641\u0629 TEXTSPLIT<\/a>. <\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":8,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":8,\"nbrPlacementsScanned\":8,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":185} --><\/p>\n<p>  \u0641\u064a \u0627\u0644\u0645\u0631\u0629 \u0627\u0644\u0642\u0627\u062f\u0645\u0629 \u0627\u0644\u062a\u064a \u062a\u0631\u064a\u062f \u0641\u064a\u0647\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0646\u0635 \u0645\u0646 \u062e\u0644\u064a\u0629 \u0623\u0648 \u062a\u0642\u0633\u064a\u0645 \u0633\u0644\u0633\u0644\u0629 \u0646\u0635\u064a\u0629 \u0637\u0648\u064a\u0644\u0629\u060c \u0636\u0639 \u0641\u064a \u0627\u0639\u062a\u0628\u0627\u0631\u0643 \u0648\u0638\u0627\u0626\u0641 Excel \u0627\u0644\u062a\u0627\u0644\u064a\u0629. \u062b\u0645 \u0639\u0646\u062f\u0645\u0627 \u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u062a\u062c\u0645\u064a\u0639 \u0627\u0644\u0633\u0644\u0627\u0633\u0644 \u0645\u0639\u064b\u0627 \u0645\u0631\u0629 \u0623\u062e\u0631\u0649\u060c \u062a\u0639\u0631\u0651\u0641 \u0639\u0644\u0649 \u0643\u064a\u0641\u064a\u0629 \u0625\u0636\u0627\u0641\u0629 \u0646\u0635 \u0628\u0633\u0647\u0648\u0644\u0629 \u0625\u0644\u0649 \u062e\u0644\u064a\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0635\u064a\u063a\u0629. <\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":8,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":8,\"nbrPlacementsScanned\":8,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":413} -->\n <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u064a\u0642\u062f\u0645 Microsoft Excel \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0644\u0644\u0639\u0645\u0644 \u0645\u0639 \u0627\u0644\u0646\u0635. \u0639\u0646\u062f\u0645\u0627 \u062a\u0631\u064a\u062f \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u062c\u0632\u0621 \u0645\u0646 \u0633\u0644\u0633\u0644\u0629 \u0646\u0635\u064a\u0629 \u0623\u0648 \u062a\u0642\u0633\u064a\u0645 \u0633\u0644\u0633\u0644\u0629 \u0625\u0644\u0649 \u0635\u0641\u0648\u0641 \u0623\u0648 \u0623\u0639\u0645\u062f\u0629\u060c \u0641\u0647\u0646\u0627\u0643 \u062b\u0644\u0627\u062b \u0648\u0638\u0627\u0626\u0641 \u0645\u0639\u064a\u0646\u0629 \u062a\u0624\u062f\u064a \u0647\u0630\u0647 \u0627\u0644\u0645\u0647\u0645\u0629. \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 TEXTBEFORE \u0648TEXTAFTER\u060c \u064a\u0645\u0643\u0646\u0643 \u0633\u062d\u0628 \u0627\u0644\u0646\u0635 \u0642\u0628\u0644 \u0623\u0648 \u0628\u0639\u062f \u0643\u0644\u0645\u0629 \u0623\u0648 \u062d\u0631\u0641 \u0645\u0639\u064a\u0646. \u0648\u0647\u0630\u0627 \u064a\u062c\u0639\u0644 \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0623\u0643\u062b\u0631 \u0645\u0631\u0648\u0646\u0629 \u0645\u0646 \u0648\u0638\u0627\u0626\u0641 LEFT \u0648RIGHT \u0648MID \u0627\u0644\u062a\u064a &#8230; <a title=\"\u0643\u064a\u0641\u064a\u0629 \u062a\u0642\u0633\u064a\u0645 \u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0644\u0646\u0635 \u0641\u064a Microsoft Excel\" class=\"read-more\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%aa%d9%82%d8%b3%d9%8a%d9%85-%d9%88%d8%a7%d8%b3%d8%aa%d8%ae%d8%b1%d8%a7%d8%ac-%d8%a7%d9%84%d9%86%d8%b5-%d9%81%d9%8a-microsoft-excel\/\" aria-label=\"Read more about \u0643\u064a\u0641\u064a\u0629 \u062a\u0642\u0633\u064a\u0645 \u0648\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0644\u0646\u0635 \u0641\u064a Microsoft Excel\">\u0625\u0642\u0631\u0623 \u0627\u0644\u0645\u0632\u064a\u062f<\/a><\/p>\n","protected":false},"author":1,"featured_media":62051,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[39,288,226],"class_list":["post-62050","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","tag-microsoft","tag-microsoft-excel","tag-microsoft-office"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AA%D9%82%D8%B3%D9%8A%D9%85-%D9%88%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC-%D8%A7%D9%84%D9%86%D8%B5-%D9%81%D9%8A-Microsoft-Excel.jpg?fit=1200%2C675&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/62050","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=62050"}],"version-history":[{"count":0,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/62050\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media\/62051"}],"wp:attachment":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media?parent=62050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/categories?post=62050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/tags?post=62050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}