{"id":15698,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/buyukharf\/"},"modified":"2021-02-25T16:38:33","modified_gmt":"2021-02-25T16:38:33","slug":"upper","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/upper\/","title":{"rendered":"B\u00dcY\u00dcKHARF"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, metin i\u015flemek i\u00e7in \u00e7e\u015fitli fonksiyonlar sunarak bilgisayar destekli \u00e7al\u0131\u015fmalar\u0131 basitle\u015ftirir. Bu fonksiyonlardan biri olan UPPER (Excel’de) veya B\u00dcY\u00dcKHARF (Google Sheets’te), bir metin dizgisini tamamen b\u00fcy\u00fck harflere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, metin tabanl\u0131 veriler \u00fczerinde i\u015flem yaparken olduk\u00e7a faydal\u0131d\u0131r. A\u015fa\u011f\u0131da, UPPER\/B\u00dcY\u00dcKHARF fonksiyonunun kullan\u0131m\u0131na ili\u015fkin detayl\u0131 a\u00e7\u0131klamalar ve \u00f6rnekler bulunmaktad\u0131r.<\/p>\n

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

UPPER fonksiyonunun Excel ve B\u00dcY\u00dcKHARF fonksiyonunun Google Sheets’teki temel s\u00f6zdizimleri \u015fu \u015fekildedir:<\/p>\n

=UPPER(text)<\/code><\/pre>\n
=B\u00dcY\u00dcKHARF(metin)<\/code><\/pre>\n
Her iki durumda da, “text” veya “metin” arg\u00fcman\u0131, b\u00fcy\u00fck harflere d\u00f6n\u00fc\u015ft\u00fcr\u00fclecek metni temsil eder.<\/p>\n
Pratik Kullan\u0131m \u00d6rnekleri<\/h2>\n
UPPER veya B\u00dcY\u00dcKHARF fonksiyonlar\u0131n\u0131 kullanman\u0131n \u00e7e\u015fitli pratik yollar\u0131 vard\u0131r. \u0130\u015fte bu fonksiyonlar\u0131n kullan\u0131labilece\u011fi baz\u0131 senaryolar:<\/p>\n
    \n
  • M\u00fc\u015fteri adlar\u0131, e-posta adresleri veya di\u011fer metin tabanl\u0131 verileri standartla\u015ft\u0131rmak.<\/li>\n
  • Belgelerde veya listelerde tutarl\u0131l\u0131k sa\u011flamak amac\u0131yla harf b\u00fcy\u00fckl\u00fcklerini d\u00fczenlemek.<\/li>\n<\/ul>\n
    Daha Detayl\u0131 \u0130nceleme \u0130\u00e7in \u00d6rnekler<\/h2>\n
    \u00d6rnek 1: Bir listedeki t\u00fcm isimleri b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek.<\/p>\n
     E\u011fer A1 h\u00fccresinde \"ali veli\" yaz\u0131yorsa, B1 h\u00fccresine =UPPER(A1) form\u00fcl\u00fc yaz\u0131ld\u0131\u011f\u0131nda sonu\u00e7 olarak \"AL\u0130 VEL\u0130\" elde edilir. <\/code><\/pre>\n
    \u00d6rnek 2: M\u00fc\u015fteri veri taban\u0131n\u0131zdaki isimler farkl\u0131 bi\u00e7imlerde kaydedilmi\u015fse, bunlar\u0131 standart bir bi\u00e7ime d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in B\u00dcY\u00dcKHARF fonksiyonunu kullanabilirsiniz.<\/p>\n
     E\u011fer A s\u00fctununda \"Ay\u015fe Y\u0131lmaz\", \"Mehmet \u00c7elik\" gibi isimler varsa, B s\u00fctununda bu isimleri b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in =B\u00dcY\u00dcKHARF(A1), =B\u00dcY\u00dcKHARF(A2) vb. form\u00fcller kullan\u0131l\u0131r. <\/code><\/pre>\n
    Yararl\u0131 \u0130pu\u00e7lar\u0131<\/h2>\n
    B\u00dcY\u00dcKHARF\/UPPER fonksiyonlar\u0131 yaln\u0131zca metni b\u00fcy\u00fck harfe \u00e7evirir; noktalama i\u015faretleri, say\u0131lar veya \u00f6zel karakterler etkilenmez. Bu fonksiyonlar, metin verileri d\u00fczenlemede ve standartla\u015ft\u0131rmada olduk\u00e7a yard\u0131mc\u0131d\u0131r. Ancak, her kullan\u0131m senaryosunda, mevcut verilerin format\u0131n\u0131 \u00f6nceden kontrol ederek d\u00f6n\u00fc\u015f\u00fcm s\u00fcrecinde olas\u0131 yanl\u0131\u015f anla\u015f\u0131lmalar\u0131 veya hatalar\u0131 en aza indirmek \u00f6nemlidir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Metni b\u00fcy\u00fck harfe \u00e7evirir<\/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-15698","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de UPPER (B\u00dcY\u00dcKHARF) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da UPPER (B\u00dcY\u00dcKHARF) 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\/upper\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de UPPER (B\u00dcY\u00dcKHARF) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da UPPER (B\u00dcY\u00dcKHARF) 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\/upper\/\" \/>\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:33+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 UPPER (B\u00dcY\u00dcKHARF) 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\/upper\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/upper\/\",\"name\":\"Excel'de UPPER (B\u00dcY\u00dcKHARF) 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:33+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da UPPER (B\u00dcY\u00dcKHARF) 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\/upper\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/upper\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/upper\/#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\":\"B\u00dcY\u00dcKHARF\"}]},{\"@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 UPPER (B\u00dcY\u00dcKHARF) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da UPPER (B\u00dcY\u00dcKHARF) 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\/upper\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de UPPER (B\u00dcY\u00dcKHARF) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da UPPER (B\u00dcY\u00dcKHARF) 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\/upper\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:38:33+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de UPPER (B\u00dcY\u00dcKHARF) 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\/upper\/","url":"https:\/\/functiontranslator.com\/tr\/upper\/","name":"Excel'de UPPER (B\u00dcY\u00dcKHARF) 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:33+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da UPPER (B\u00dcY\u00dcKHARF) 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\/upper\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/upper\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/upper\/#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":"B\u00dcY\u00dcKHARF"}]},{"@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\/15698","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=15698"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15698\/revisions"}],"predecessor-version":[{"id":26966,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15698\/revisions\/26966"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}