{"id":1814,"date":"2023-08-16T14:58:40","date_gmt":"2023-08-16T11:58:40","guid":{"rendered":"https:\/\/hakanarslan.net\/?p=1814"},"modified":"2023-08-16T15:52:18","modified_gmt":"2023-08-16T12:52:18","slug":"excel-ile-hucrede-birden-fazla-kelimeyi-arayip-bulunan-kelimeye-gore-cikti-alalim","status":"publish","type":"post","link":"https:\/\/hakanarslan.net\/excel-ile-hucrede-birden-fazla-kelimeyi-arayip-bulunan-kelimeye-gore-cikti-alalim.html","title":{"rendered":"Excel \u0130le H\u00fccrede Birden Fazla Kelimeyi Aray\u0131p, Bulunan Kelimeye G\u00f6re \u00c7\u0131kt\u0131 Alal\u0131m"},"content":{"rendered":"\n<p>Selamlar, yaz\u0131n\u0131n ba\u015fl\u0131\u011f\u0131nda konuyu tam olarak anlatabildim mi bilmiyorum, ama bu form\u00fcl benim g\u00fcn\u00fcm\u00fc kurtard\u0131, belki size de faydas\u0131 olur.<\/p>\n\n\n\n<p>Yapmak istedi\u011fim \u015fuydu, h\u00fccredeki metinde ula\u015fmak istedi\u011fim bir dizi kelime var, e\u011fer arama yapaca\u011f\u0131m h\u00fccrede bu kelimeler varsa virg\u00fcllerle ay\u0131rarak, belirledi\u011fim \u015fekilde ba\u015fka bir h\u00fccreye yazs\u0131n. <\/p>\n\n\n\n<p>Uzatmadan \u00f6rne\u011fi vereyim;<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=MET\u0130NB\u0130RLE\u015eT\u0130R(\", \";DO\u011eRU;E\u011eER(ESAYIYSA(MBUL({\"PHP\";\"Laravel\";\"C#\"};A1));{\"PHP\";\"Laravel\";\".Net\"};\"\"))\n<\/pre>\n\n\n\n<p>A1 h\u00fccresinde \u015funun yazd\u0131\u011f\u0131n\u0131 varsayal\u0131m; &#8220;PHP&#8217;yi seviyorum, ama bu aralar C# ile ilgileniyorum&#8221;<\/p>\n\n\n\n<p>B1&#8217;e bu form\u00fcl\u00fc yerle\u015ftirdi\u011fimizde \u00e7\u0131kt\u0131 \u015f\u00f6yle olacak; PHP, .Net<\/p>\n\n\n\n<p>Bu arada Excel&#8217;de bu form\u00fcller b\u00fct\u00fcn\u00fcn\u00fc yazacak kadar bilgili de\u011filim, Microsoft yard\u0131m sayfas\u0131nda \u0130ngilizce Excel i\u00e7in yap\u0131lm\u0131\u015f versiyonunu T\u00fcrk\u00e7e Excel&#8217;de kullan\u0131lacak hale \u00e7evirdim, bu y\u00fczden kaynak g\u00f6stermeliyim : <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel\/need-to-search-multiple-words-in-a-cell-and-get-the-output-based\/m-p\/2490889#M104831\" data-type=\"link\" data-id=\"https:\/\/techcommunity.microsoft.com\/t5\/excel\/need-to-search-multiple-words-in-a-cell-and-get-the-output-based\/m-p\/2490889#M104831\" target=\"_blank\" rel=\"noreferrer noopener\">Need to search multiple words in a cell and get the output based on the word found<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Sizin i\u00e7in de faydal\u0131 olduysa kanal\u0131ma abone olmay\u0131 ve like&#8230; \u015faka \u015faka bi&#8217; yorumunuzu al\u0131r\u0131m ;) <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Selamlar, yaz\u0131n\u0131n ba\u015fl\u0131\u011f\u0131nda konuyu tam olarak anlatabildim mi bilmiyorum, ama bu form\u00fcl benim g\u00fcn\u00fcm\u00fc kurtard\u0131, belki size de faydas\u0131 olur. Yapmak istedi\u011fim \u015fuydu, h\u00fccredeki metinde ula\u015fmak istedi\u011fim bir dizi kelime var, e\u011fer arama yapaca\u011f\u0131m h\u00fccrede bu kelimeler varsa virg\u00fcllerle ay\u0131rarak, belirledi\u011fim \u015fekilde ba\u015fka bir h\u00fccreye yazs\u0131n. Uzatmadan \u00f6rne\u011fi vereyim; A1 h\u00fccresinde \u015funun yazd\u0131\u011f\u0131n\u0131 varsayal\u0131m; &#8220;PHP&#8217;yi&#8230; <a class=\"more-link\" href=\"https:\/\/hakanarslan.net\/excel-ile-hucrede-birden-fazla-kelimeyi-arayip-bulunan-kelimeye-gore-cikti-alalim.html\">Continue reading <span class=\"meta-nav\">&#8594;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1626,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[6],"tags":[345,346],"views":144,"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/hakanarslan.net\/wp-content\/uploads\/excel.png?fit=309%2C163&ssl=1","_links":{"self":[{"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/posts\/1814"}],"collection":[{"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/comments?post=1814"}],"version-history":[{"count":5,"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/posts\/1814\/revisions"}],"predecessor-version":[{"id":1821,"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/posts\/1814\/revisions\/1821"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/media\/1626"}],"wp:attachment":[{"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/media?parent=1814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/categories?post=1814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hakanarslan.net\/wp-json\/wp\/v2\/tags?post=1814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}