{"id":15688,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kirp\/"},"modified":"2021-02-25T16:38:06","modified_gmt":"2021-02-25T16:38:06","slug":"trim","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/trim\/","title":{"rendered":"KIRP"},"content":{"rendered":"<h2>Neden ve Nas\u0131l: Metin Temizli\u011fi<\/h2>\n<p> \u00c7al\u0131\u015fma sayfalar\u0131yla u\u011fra\u015fan herkes, \u00f6zellikle b\u00fcy\u00fck veri setleri s\u00f6z konusu oldu\u011funda, metinler aras\u0131nda s\u0131k\u00e7a rastlanan gereksiz bo\u015fluklarla kar\u015f\u0131la\u015fm\u0131\u015ft\u0131r. Bu gereksiz bo\u015fluklar, veri analizi yaparken veya veri tabanlar\u0131 aras\u0131nda veri aktar\u0131m\u0131 ger\u00e7ekle\u015ftirirken sorunlara yol a\u00e7abilir. MS Excel ve Google E-Tablolar, bu t\u00fcr yayg\u0131n sorunlar\u0131 \u00e7\u00f6zmek i\u00e7in <code>TRIM<\/code> (KIRP) i\u015flevini sunar. <\/p>\n<h2>\u0130\u015flevin S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n<p> <code>TRIM<\/code> i\u015flevi, metin i\u00e7indeki fazladan bo\u015fluklar\u0131 kald\u0131rarak d\u00fczenlenmi\u015f bir metin d\u00f6nd\u00fcr\u00fcr. \u0130\u015flevin s\u00f6zdizimi, her iki platformda da benzerdir: <\/p>\n<pre> <code>TRIM(metin)<\/code> <\/pre>\n<p> Burada &#8220;metin&#8221; arg\u00fcman\u0131, k\u0131rpmak istedi\u011finiz metni i\u00e7eren h\u00fccreyi veya do\u011frudan metin de\u011ferini ifade eder. <\/p>\n<h2>Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n<ul>\n<li> <strong>\u0130stenmeyen Bo\u015fluklar\u0131 Temizleme:<\/strong>\n<p>Bir m\u00fc\u015fteri listesinde isimlerin ba\u015f\u0131nda veya sonunda yer alan gereksiz bo\u015fluklar, e-posta listelerini d\u00fczenlerken veya adres etiketleri basarken hatalara neden olabilir. <code>TRIM<\/code> fonksiyonu bu bo\u015fluklar\u0131 kolayl\u0131kla temizler:<\/p>\n<pre> <code>=TRIM(A1)<\/code> <\/pre>\n<p>Yukar\u0131daki form\u00fcl, A1 h\u00fccresinde bulunan metnin ba\u015f\u0131nda ve sonunda bulunan gereksiz bo\u015fluklar\u0131 kald\u0131r\u0131r. Ayr\u0131ca kelime aralar\u0131ndaki birden fazla bo\u015flu\u011fu tek bo\u015flu\u011fa indirger.<\/p>\n<\/li>\n<li> <strong>Veri \u0130\u00e7e Aktar\u0131m\u0131 S\u0131ras\u0131nda D\u00fczenleme:<\/strong>\n<p>\u00c7o\u011fu zaman, d\u0131\u015far\u0131dan al\u0131nan veriler ekstra bo\u015fluklar i\u00e7erebilir. Bu bo\u015fluklar, verilerin do\u011fru \u015fekilde i\u015flenmesini \u00f6nleyebilir. \u00d6rne\u011fin, kullan\u0131c\u0131 adlar\u0131 veya anahtar kelimeler \u00fczerinde \u00e7al\u0131\u015f\u0131rken bu temizlik \u00f6nemlidir:<\/p>\n<pre> <code>=TRIM(B2)<\/code> <\/pre>\n<p>Burada, B2 h\u00fccresinden gelen veri \u00fczerinde <code>TRIM<\/code> i\u015flevi uygulanarak, fazladan bo\u015fluklar ar\u0131nd\u0131r\u0131lm\u0131\u015f olur. Bu i\u015flem, veri do\u011frulu\u011funu ve konsistans\u0131n\u0131 sa\u011flamak i\u00e7in \u00f6nemlidir.<\/p>\n<\/li>\n<\/ul>\n<h2>Yorumlar ve \u0130pu\u00e7lar\u0131<\/h2>\n<p> <code>TRIM<\/code> i\u015flevi yaln\u0131zca metinlerdeki fazla alanlar\u0131 temizlemek i\u00e7in kullan\u0131labilir; yani metinde yer alan tab veya di\u011fer \u00f6zel bo\u015fluk karakterleri (\u00f6rne\u011fin, non-breaking spaces) \u00fczerinde etkisi olmayabilir. Baz\u0131 durumlarda, \u00f6zellikle veri ba\u015fka sistemlerden al\u0131nd\u0131\u011f\u0131nda, bu t\u00fcr \u00f6zel bo\u015fluklar da problem yaratabilir. Bu gibi durumlar i\u00e7in Google E-Tablolar&#8217;da <code>SUBSTITUTE<\/code> i\u015flevi ve Excel&#8217;de ekstra temizlik fonksiyonlar\u0131 kullan\u0131labilir. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Metindeki bo\u015fluklar\u0131 kald\u0131r\u0131r<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[581],"tags":[],"class_list":["post-15688","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de TRIM (KIRP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da TRIM (KIRP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/trim\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de TRIM (KIRP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da TRIM (KIRP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/trim\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:38:06+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de TRIM (KIRP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/trim\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/trim\/\",\"name\":\"Excel'de TRIM (KIRP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:38:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TRIM (KIRP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/trim\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/trim\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/trim\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Metin\",\"item\":\"https:\/\/functiontranslator.com\/tr\/metin\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"KIRP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de TRIM (KIRP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TRIM (KIRP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/tr\/trim\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TRIM (KIRP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TRIM (KIRP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/trim\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:38:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TRIM (KIRP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/trim\/","url":"https:\/\/functiontranslator.com\/tr\/trim\/","name":"Excel'de TRIM (KIRP) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:38:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TRIM (KIRP) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/trim\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/trim\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/trim\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Metin","item":"https:\/\/functiontranslator.com\/tr\/metin\/"},{"@type":"ListItem","position":3,"name":"KIRP"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15688"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15688\/revisions"}],"predecessor-version":[{"id":26956,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15688\/revisions\/26956"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}