{"id":15618,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/sagdan-sagb-islevleri\/"},"modified":"2021-03-01T16:47:40","modified_gmt":"2021-03-01T16:47:40","slug":"right-rightbs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/right-rightbs\/","title":{"rendered":"SA\u011eDAN, SA\u011eB"},"content":{"rendered":"

Bir Metin \u0130\u015fleme \u0130\u015flevi Olarak Metnin Sa\u011fdan Al\u0131nmas\u0131<\/h2>\n

Microsoft Excel ve Google E-Tablolar kullan\u0131c\u0131lar\u0131 i\u00e7in metin i\u015fleme fonksiyonlar\u0131 olduk\u00e7a \u00f6nemlidir. \u00d6zellikle, metinler \u00fczerinde spesifik manip\u00fclasyonlar yapmak istedi\u011finizde bu fonksiyonlar kritik hale gelir. Bu yaz\u0131da, “RIGHT” ya da T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131yla “SA\u011eDAN” i\u015flevinin kullan\u0131m\u0131n\u0131 ve pratik uygulamalar\u0131n\u0131 inceleyece\u011fiz. Google E-Tablolar\u2019da bu i\u015flev “SA\u011eB” olarak bilinir ve genellikle benzer ama\u00e7lar i\u00e7in kullan\u0131l\u0131r.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi ve Temel Kullan\u0131m\u0131<\/h2>\n

Her iki programda da i\u015flev, bir metin stringinden sa\u011f taraftan belirli bir say\u0131da karakteri alma i\u015flevini yerine getirir. \u0130\u015flevin genel yap\u0131lar\u0131 a\u015fa\u011f\u0131daki gibidir:<\/p>\n

 Excel i\u00e7in:  =RIGHT(text, [num_chars]) <\/code> Google E-Tablolar i\u00e7in:  =RIGHTB(text, [num_bytes]) <\/code> <\/pre>\n
    \n
  • text<\/strong>: Sa\u011f taraf\u0131 al\u0131nacak orijinal metin.<\/li>\n
  • num_chars\/num_bytes<\/strong>: Al\u0131nacak karakter say\u0131s\u0131. Bu parametre opsiyoneldir ve varsay\u0131lan de\u011feri 1’dir.<\/li>\n<\/ul>\n
    \u00d6rnek olarak, bir h\u00fccredeki (A1) “Merhaba D\u00fcnya!” ifadesinin son 6 karakterini almak isteyebilirsiniz:<\/p>\n
      Excel: =RIGHT(A1, 6) \u00e7\u0131kt\u0131s\u0131 olarak \"D\u00fcnya!\" verir. Google E-Tablolar: =RIGHTB(A1, 6) \u00e7\u0131kt\u0131s\u0131 olarak \"D\u00fcnya!\" verir. <\/code> <\/pre>\n
    \u0130\u015flevi Kullanarak Adres Bilgisi Ay\u0131klama<\/h2>\n
    Adres gibi bilgiler genellikle sonundaki \u015fehir veya posta kodunu \u00e7\u0131karmak i\u00e7in “RIGHT” fonksiyonundan yararlan\u0131l\u0131r. Diyelim ki, A2 h\u00fccresinde bulunan “3452 JD Amsterdam” adresinden sadece posta kodunu ay\u0131klamak istiyorsunuz. Posta kodu genelde 6 karakterden olu\u015fmaktad\u0131r:<\/p>\n
      Excel: =RIGHT(A2, 6) \u00e7\u0131kt\u0131s\u0131 olarak \"3452 JD\" olur. Google E-Tablolar: =RIGHTB(A2, 6) ile sonucu \"3452 JD\" al\u0131rs\u0131n\u0131z. <\/code> <\/pre>\n
    Yukar\u0131daki i\u015flem sayesinde, adresler \u00fczerindeki belirli bilgileri kolayl\u0131kla \u00e7ekebilirsiniz, bu sayede listelerinizi daha efektif bir \u015fekilde s\u0131n\u0131fland\u0131rabilirsiniz.<\/p>\n
    Belirli Bir Metin \u0130\u00e7inde Anahtar Kelime Ararken Kullan\u0131m<\/h2>\n
    Bir e-mail adresi listesi d\u00fc\u015f\u00fcn\u00fcn ve bu e-mail adreslerinin domain’lerini (\u00f6rne\u011fin @gmail.com, @hotmail.com) ay\u0131klamak istiyorsunuz. E\u011fer t\u00fcm e-mail adresleri benzer uzunluktaysa, “RIGHT” i\u015flevi kullanarak domain’ler ay\u0131klanabilir. Ancak, bu metot her zaman i\u015fe yaramayabilir \u00e7\u00fcnk\u00fc de\u011fi\u015fken uzunluklarda e-posta adresleriyle kar\u015f\u0131la\u015f\u0131labilir. Bu durumda, “FIND” veya “SEARCH” i\u015flevleri ile birle\u015ftirilerek kullan\u0131lmas\u0131 daha i\u015flevsel olur.<\/p>\n
      Excel: =RIGHTB(A3, LEN(A3) - FIND(\"@\", A3)) Google E-Tablolar: =RIGHTB(A3, LEN(A3) - SEARCH(\"@\", A3)) <\/code> <\/pre>\n
    Bu y\u00f6ntem, “@” simgesinin pozisyonunu bulur, toplam uzunluktan \u00e7\u0131kar\u0131r ve sonucu “RIGHT” fonksiyonuna g\u00f6nderir. Bu \u015fekilde, de\u011fi\u015fen uzunluklardaki e-mail adreslerinden kolayl\u0131kla domain k\u0131sm\u0131n\u0131 ay\u0131rabilirsiniz.<\/p>\n
    Yaz\u0131m\u0131z\u0131n sonunda, “RIGHT” ve “RIGHTB” i\u015flevlerinin Excel ve Google E-Tablolar’da nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ve \u00e7e\u015fitli senaryolarda nas\u0131l kullan\u0131\u015fl\u0131 olabilece\u011fini g\u00f6rd\u00fck. Veriler \u00fczerinde do\u011fru manip\u00fclasyonlar yapmak, veri analizi ve y\u00f6netimi konusundaki becerilerinizi geli\u015ftirecektir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir metin de\u011ferinden en sa\u011fdaki karakterleri 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-15618","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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\/right-rightbs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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\/right-rightbs\/\" \/>\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-03-01T16:47:40+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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\/right-rightbs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/right-rightbs\/\",\"name\":\"Excel'de RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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-03-01T16:47:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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\/right-rightbs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/right-rightbs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/right-rightbs\/#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\":\"SA\u011eDAN, SA\u011eB\"}]},{\"@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 RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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\/right-rightbs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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\/right-rightbs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-03-01T16:47:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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\/right-rightbs\/","url":"https:\/\/functiontranslator.com\/tr\/right-rightbs\/","name":"Excel'de RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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-03-01T16:47:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da RIGHT, RIGHTBs (SA\u011eDAN, SA\u011eB) 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\/right-rightbs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/right-rightbs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/right-rightbs\/#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":"SA\u011eDAN, SA\u011eB"}]},{"@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\/15618","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=15618"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15618\/revisions"}],"predecessor-version":[{"id":32547,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15618\/revisions\/32547"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}