{"id":15511,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/uzunluk-uzunlukb-islevleri\/"},"modified":"2021-03-01T16:47:48","modified_gmt":"2021-03-01T16:47:48","slug":"len-lenbs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/len-lenbs\/","title":{"rendered":"UZUNLUK, UZUNLUKB"},"content":{"rendered":"<h1>Metin Uzunlu\u011funu Hesaplama Rehberi<\/h1>\n<p>Metinlerle \u00e7al\u0131\u015f\u0131rken s\u0131kl\u0131kla metin uzunlu\u011funu \u00f6l\u00e7mek gerekebilir. Bu ihtiya\u00e7, veri analizinden veri do\u011frulamas\u0131na kadar bir\u00e7ok farkl\u0131 alanda kar\u015f\u0131m\u0131za \u00e7\u0131kabilir. Microsoft Excel ve Google E-Tablolar, metin uzunlu\u011funu \u00f6l\u00e7mek i\u00e7in kullan\u0131lan iki pop\u00fcler ara\u00e7t\u0131r ve her ikisi de bu i\u015flevi ger\u00e7ekle\u015ftirmek i\u00e7in benzer fonksiyonlara sahiptir. Bu makalede, Excel ve Google E-Tablolar&#8217;da kullan\u0131lan LEN ve LENB (Excel i\u00e7in) fonksiyonlar\u0131n\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6rneklerle birlikte inceleyece\u011fiz.<\/p>\n<h2>Metin Uzunlu\u011funun Hesaplanmas\u0131<\/h2>\n<p>Bu iki fonksiyon, verilen metin dizisinin karakter say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Haydi bu iki fonksiyonun kullan\u0131m\u0131na ve \u00e7e\u015fitli durumlardaki uygulamalar\u0131na detayl\u0131 bir bak\u0131\u015f atal\u0131m.<\/p>\n<ul>\n<li><strong>LEN<\/strong>: Verilen metin dizisindeki karakter say\u0131s\u0131n\u0131 hesaplar. Bu i\u015flev sadece standart karakterleri hesaba katar.<\/li>\n<li><strong>LENB<\/strong> (Sadece Excel): Verilen metin dizisindeki bayt say\u0131s\u0131n\u0131 hesaplar. Genellikle \u00e7ift baytl\u0131 karakter setleri (DBCS) i\u00e7in kullan\u0131l\u0131r.<\/li>\n<\/ul>\n<pre> <code> =LEN(\"Merhaba D\u00fcnya\") \/\/ 12 karakter d\u00f6nd\u00fcr\u00fcr =LENB(\"Merhaba D\u00fcnya\") \/\/ Excel'de 24 bayt d\u00f6nd\u00fcr\u00fcr <\/code> <\/pre>\n<h2>Pratik Uygulamalar<\/h2>\n<p>Metin uzunlu\u011funu \u00f6l\u00e7mek, bir\u00e7ok farkl\u0131 durumda faydal\u0131 olabilir. \u0130\u015fte bu fonksiyonlar\u0131n kullan\u0131labilece\u011fi iki pratik \u00f6rnek:<\/p>\n<h3>Veri Do\u011frulama<\/h3>\n<p>Kullan\u0131c\u0131lar\u0131n girdi\u011fi metinlerin belirli bir uzunlukta olmas\u0131 gerekti\u011fi durumlar olabilir. \u00d6rne\u011fin, bir kullan\u0131c\u0131 ad\u0131n\u0131n en az 6 karakter uzunlu\u011funda olmas\u0131 gerekti\u011fini varsayal\u0131m. Bu kontrol\u00fc a\u015fa\u011f\u0131daki gibi yapabiliriz:<\/p>\n<pre> <code> =IF(LEN(A1) &gt;= 6, \"Ge\u00e7erli\", \"Ge\u00e7ersiz\") <\/code> <\/pre>\n<p>Bu form\u00fcl, A1 h\u00fccresindeki metinin 6 veya daha fazla karakter i\u00e7erip i\u00e7ermedi\u011fini kontrol eder ve buna g\u00f6re &#8220;Ge\u00e7erli&#8221; veya &#8220;Ge\u00e7ersiz&#8221; sonucunu d\u00f6nd\u00fcr\u00fcr.<\/p>\n<h3>Veri Analizi<\/h3>\n<p>Metin uzunluklar\u0131n\u0131n analiz edilmesi, metin verilerinin yap\u0131s\u0131n\u0131 anlamak i\u00e7in \u00f6nemlidir. \u00d6rne\u011fin, m\u00fc\u015fteri yorumlar\u0131n\u0131n uzunluklar\u0131 \u00fczerinden bir analiz yaparak, daha uzun yorumlar\u0131n daha fazla bilgi i\u00e7erdi\u011fini varsayabiliriz. Bu analizi yapmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/p>\n<pre> <code> =AVERAGE(LEN(A1:A100)) <\/code> <\/pre>\n<p>Bu form\u00fcl, A1&#8217;den A100&#8217;e kadar olan h\u00fccrelerdeki metinlerin ortalama uzunlu\u011funu hesaplar. Uzun metinlerin ortalamas\u0131 daha y\u00fcksek bir say\u0131 verecektir, bu da veri setinizdeki genel metin boyutu hakk\u0131nda bilgi verir.<\/p>\n<p>Excel ve Google E-Tablolar, metin i\u015fleme i\u015flevlerini y\u00fcr\u00fctmek i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. LEN ve LENB fonksiyonlar\u0131, bu i\u015flevler i\u00e7inde s\u0131k\u00e7a kullan\u0131lan ara\u00e7lardan sadece birka\u00e7\u0131d\u0131r ve do\u011fru kullan\u0131ld\u0131\u011f\u0131nda veri y\u00f6netimi g\u00f6revlerinizi b\u00fcy\u00fck \u00f6l\u00e7\u00fcde kolayla\u015ft\u0131rabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Metin dizesindeki karakter say\u0131s\u0131n\u0131 verir<\/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-15511","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 LEN, LENBs (UZUNLUK, UZUNLUKB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da LEN, LENBs (UZUNLUK, UZUNLUKB) 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\/len-lenbs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de LEN, LENBs (UZUNLUK, UZUNLUKB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da LEN, LENBs (UZUNLUK, UZUNLUKB) 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\/len-lenbs\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-01T16:47:48+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 LEN, LENBs (UZUNLUK, UZUNLUKB) 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\/len-lenbs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/len-lenbs\/\",\"name\":\"Excel'de LEN, LENBs (UZUNLUK, UZUNLUKB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-03-01T16:47:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da LEN, LENBs (UZUNLUK, UZUNLUKB) 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\/len-lenbs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/len-lenbs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/len-lenbs\/#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\":\"UZUNLUK, UZUNLUKB\"}]},{\"@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 LEN, LENBs (UZUNLUK, UZUNLUKB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da LEN, LENBs (UZUNLUK, UZUNLUKB) 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\/len-lenbs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de LEN, LENBs (UZUNLUK, UZUNLUKB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da LEN, LENBs (UZUNLUK, UZUNLUKB) 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\/len-lenbs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-03-01T16:47:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de LEN, LENBs (UZUNLUK, UZUNLUKB) 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\/len-lenbs\/","url":"https:\/\/functiontranslator.com\/tr\/len-lenbs\/","name":"Excel'de LEN, LENBs (UZUNLUK, UZUNLUKB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-03-01T16:47:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da LEN, LENBs (UZUNLUK, UZUNLUKB) 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\/len-lenbs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/len-lenbs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/len-lenbs\/#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":"UZUNLUK, UZUNLUKB"}]},{"@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\/15511","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=15511"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15511\/revisions"}],"predecessor-version":[{"id":32549,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15511\/revisions\/32549"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}