{"id":4951,"date":"2023-01-22T14:40:40","date_gmt":"2023-01-22T11:40:40","guid":{"rendered":"https:\/\/1.cbm.ua\/?p=4951"},"modified":"2023-10-31T12:36:13","modified_gmt":"2023-10-31T09:36:13","slug":"chat-gpt-%d0%bd%d0%b0%d0%bf%d0%b8%d1%81%d0%b0%d0%bb-%d1%84%d0%be%d1%80%d0%bc%d1%83%d0%bb%d1%83-%d0%b4%d0%bb%d1%8f-%d0%b2%d1%8b%d0%b4%d0%b5%d0%bb%d0%b5%d0%bd%d0%b8%d0%b5-%d1%82%d1%80%d0%b5%d1%82%d0%b5","status":"publish","type":"post","link":"https:\/\/1.cbm.ua\/?p=4951","title":{"rendered":"Chat-GPT \u0434\u043b\u044f Excel \u043d\u0430\u043f\u0438\u0441\u0430\u043b \u0444\u043e\u0440\u043c\u0443\u043b\u0443 \u0434\u043b\u044f \u0432\u044b\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0442\u0440\u0435\u0442\u0435\u0433\u043e \u0441\u043b\u043e\u0432\u0430 \u0438\u043b\u0438 \u0433\u043b\u0443\u0431\u0436\u0435 (\u0440\u0430\u0437\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0431\u0435\u043b\u0430\u043c\u0438)."},"content":{"rendered":"\n<p><strong><a href=\"https:\/\/youtu.be\/uor4N7w6xu0?t=433\" data-type=\"URL\" data-id=\"https:\/\/youtu.be\/uor4N7w6xu0?t=433\" target=\"_blank\" rel=\"noreferrer noopener\">URL \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a<\/a><\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"nv-iframe-embed\"><iframe loading=\"lazy\" title=\"\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c ChatGPT \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0432 Excel\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/uor4N7w6xu0?start=433&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u043f\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0443.<br><strong>&#171;I have a long text in cell A1 in Microsoft Excel. Write a formula to get second word from this text&#187;<br><\/strong>\u0423 \u043c\u0435\u043d\u044f \u0435\u0441\u0442\u044c \u0434\u043b\u0438\u043d\u043d\u044b\u0439 \u0442\u0435\u043a\u0441\u0442 \u0432 \u044f\u0447\u0435\u0439\u043a\u0435 A1 \u0432 Microsoft Excel. \u041d\u0430\u043f\u0438\u0448\u0438\u0442\u0435 \u0444\u043e\u0440\u043c\u0443\u043b\u0443, \u0447\u0442\u043e\u0431\u044b \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0432\u0442\u043e\u0440\u043e\u0435 \u0441\u043b\u043e\u0432\u043e \u0438\u0437 \u044d\u0442\u043e\u0433\u043e \u0442\u0435\u043a\u0441\u0442\u0430.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>= MID(A1; FIND(&#187; &#171;; A1; FIND(&#187; &#171;; A1) + 1)+1; FIND(&#187; &#171;; A1; FIND(&#187; &#171;; A1; FIND(&#187; &#171;; A1) +1) +1) &#8212; FIND(&#187; &#171;; A1; FIND(&#187; &#171;; A1) +1) -1)<\/p>\n\n\n\n<p>\u0444\u043e\u0440\u043c\u0443\u043b\u044b \u0434\u043b\u044f Excel \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0432 \u044f\u0447\u0435\u0439\u043a\u0435 A1<br>= \u041f\u0421\u0422\u0420(A:A; 1 ; \u041d\u0410\u0419\u0422\u0418(&#187; (&#171;; A1; 1)-1 )<br>= \u041f\u0421\u0422\u0420(A:A; \u041d\u0410\u0419\u0422\u0418(&#187; (&#171;; A:A; 1) ; \u041d\u0410\u0419\u0422\u0418(&#171;)&#187;; A1; 1) )<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><a href=\"https:\/\/semtools.guru\/ru\/beginner-howto\/poisk-s-kontsa-stroki-v-excel\/\" data-type=\"URL\" data-id=\"https:\/\/semtools.guru\/ru\/beginner-howto\/poisk-s-kontsa-stroki-v-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">URL \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a<\/a><\/p>\n\n\n\n<p>\u0424\u043e\u0440\u043c\u0443\u043b\u0430 \u0434\u043b\u044f \u043f\u043e\u0438\u0441\u043a \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043f\u0440\u043e\u0431\u0435\u043b\u0430 \u0432 \u0441\u0442\u0440\u043e\u043a\u0435 \u0438 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u043d\u0430 \u0434\u0432\u0435 \u0441\u0442\u0440\u043e\u043a\u0438, \u0434\u043e \u0438 \u043f\u043e\u0441\u043b\u0435 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043f\u0440\u043e\u0431\u0435\u043b\u0430.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"76\" src=\"https:\/\/fjngqp1mvftjzxfzrdiggafze9wxueam.cdn-freehost.com.ua\/wp-content\/uploads\/2023\/02\/image-14.png\" alt=\"\" class=\"wp-image-5229\" srcset=\"https:\/\/fjngqp1mvftjzxfzrdiggafze9wxueam.cdn-freehost.com.ua\/wp-content\/uploads\/2023\/02\/image-14.png 559w, https:\/\/fjngqp1mvftjzxfzrdiggafze9wxueam.cdn-freehost.com.ua\/wp-content\/uploads\/2023\/02\/image-14-300x41.png 300w\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" \/><\/figure>\n\n\n\n<p>\u0432 &#171;C&#187; &#8212; \u0444\u0440\u0430\u0437\u0430 \u0434\u043e \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0433\u043e \u043f\u0440\u043e\u0431\u0435\u043b\u0430.<\/p>\n\n\n\n<p>B  =\u041f\u041e\u0418\u0421\u041a(&#171;\\&#187;;\u041f\u041e\u0414\u0421\u0422\u0410\u0412\u0418\u0422\u042c(A2;&#187; &#171;;&#187;\\&#187;;\u0414\u041b\u0421\u0422\u0420(A2)-\u0414\u041b\u0421\u0422\u0420(\u041f\u041e\u0414\u0421\u0422\u0410\u0412\u0418\u0422\u042c(A2;&#187; &#171;;&#187;&#187;))))<\/p>\n\n\n\n<p>C  = \u041f\u0421\u0422\u0420(A:A; 1; B:B)<\/p>\n\n\n\n<p>D = \u041f\u0421\u0422\u0420(A:A; B:B; \u0414\u041b\u0421\u0422\u0420(A:A) )<\/p>\n","protected":false},"excerpt":{"rendered":"<p>URL \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a. \u043f\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0443.&#171;I have a long text in cell A1 in Microsoft Excel. Write a formula to get second word from this text&#187;\u0423 \u043c\u0435\u043d\u044f \u0435\u0441\u0442\u044c \u0434\u043b\u0438\u043d\u043d\u044b\u0439 \u0442\u0435\u043a\u0441\u0442 \u0432 \u044f\u0447\u0435\u0439\u043a\u0435 A1 \u0432 Microsoft Excel. \u041d\u0430\u043f\u0438\u0448\u0438\u0442\u0435 \u0444\u043e\u0440\u043c\u0443\u043b\u0443, \u0447\u0442\u043e\u0431\u044b \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0432\u0442\u043e\u0440\u043e\u0435 \u0441\u043b\u043e\u0432\u043e \u0438\u0437 \u044d\u0442\u043e\u0433\u043e \u0442\u0435\u043a\u0441\u0442\u0430. = MID(A1; FIND(&#187; &#171;; A1; FIND(&#187; &#171;; A1) + 1)+1; FIND(&#187; &#171;;&hellip;&nbsp;<a href=\"https:\/\/1.cbm.ua\/?p=4951\" rel=\"bookmark\">\u041f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435 &raquo;<span class=\"screen-reader-text\">Chat-GPT \u0434\u043b\u044f Excel \u043d\u0430\u043f\u0438\u0441\u0430\u043b \u0444\u043e\u0440\u043c\u0443\u043b\u0443 \u0434\u043b\u044f \u0432\u044b\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0442\u0440\u0435\u0442\u0435\u0433\u043e \u0441\u043b\u043e\u0432\u0430 \u0438\u043b\u0438 \u0433\u043b\u0443\u0431\u0436\u0435 (\u0440\u0430\u0437\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0435 \u043f\u0440\u043e\u0431\u0435\u043b\u0430\u043c\u0438).<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[154,158],"tags":[],"class_list":["post-4951","post","type-post","status-publish","format-standard","hentry","category-chat-gpt","category-excel"],"_links":{"self":[{"href":"https:\/\/1.cbm.ua\/index.php?rest_route=\/wp\/v2\/posts\/4951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1.cbm.ua\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/1.cbm.ua\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/1.cbm.ua\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/1.cbm.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4951"}],"version-history":[{"count":8,"href":"https:\/\/1.cbm.ua\/index.php?rest_route=\/wp\/v2\/posts\/4951\/revisions"}],"predecessor-version":[{"id":5744,"href":"https:\/\/1.cbm.ua\/index.php?rest_route=\/wp\/v2\/posts\/4951\/revisions\/5744"}],"wp:attachment":[{"href":"https:\/\/1.cbm.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/1.cbm.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/1.cbm.ua\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}