{"id":15600,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yazim-duzeni\/"},"modified":"2021-02-25T16:34:06","modified_gmt":"2021-02-25T16:34:06","slug":"proper","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/proper\/","title":{"rendered":"YAZIM.D\u00dcZEN\u0130"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri analizi ve i\u015fleme i\u00e7in geni\u015f bir fonksiyon yelpazesi sunar. Bu fonksiyonlardan biri olan YAZIM.D\u00dcZEN\u0130 (PROPER), metni “Ba\u015fl\u0131k Bi\u00e7imi”ne d\u00f6n\u00fc\u015ft\u00fcrerek her kelimenin ilk harfini b\u00fcy\u00fck yapar ve di\u011fer harfleri k\u00fc\u00e7\u00fck hale getirir. Bu fonksiyon, \u00f6zellikle ki\u015fisel isimlerin ve adres bilgilerinin standart bi\u00e7ime sokulmas\u0131 i\u00e7in s\u0131k\u00e7a tercih edilir.<\/p>\n

YAZIM.D\u00dcZEN\u0130 Fonksiyonunun S\u00f6zdizimi<\/h2>\n

YAZIM.D\u00dcZEN\u0130 fonksiyonunun temel kullan\u0131m \u015fekli \u015f\u00f6yledir:<\/p>\n

=YAZIM.D\u00dcZEN\u0130(metin)<\/code><\/pre>\n
    \n
  • metin:<\/strong> Ba\u015fl\u0131k bi\u00e7imine d\u00f6n\u00fc\u015ft\u00fcr\u00fclecek metni i\u00e7eren arg\u00fcmand\u0131r. Bu arg\u00fcman do\u011frudan metin \u015feklinde veya bir h\u00fccre referans\u0131 i\u00e7erebilir.<\/li>\n<\/ul>\n
    Fonksiyonun Kullan\u0131m\u0131na \u0130li\u015fkin \u00d6rnekler<\/h2>\n
    \u00d6\u011frenci isimlerinin ilk harflerini b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in:<\/p>\n
    =YAZIM.D\u00dcZEN\u0130(A1)<\/code><\/pre>\n
    E\u011fer A1 h\u00fccresi “ahmet y\u0131lmaz” i\u00e7eriyorsa, fonksiyon “Ahmet Y\u0131lmaz” \u015feklinde bir \u00e7\u0131kt\u0131 verir.<\/p>\n
    Adres listesi d\u00fczenleme \u00f6rne\u011fi:<\/p>\n
    =YAZIM.D\u00dcZEN\u0130(B2)<\/code><\/pre>\n
    B2 h\u00fccresi “istanbul\/t\u00fcrkiye” yazd\u0131\u011f\u0131nda, sonu\u00e7 “Istanbul\/T\u00fcrkiye” olarak d\u00f6n\u00fc\u015f yapar.<\/p>\n
    Ger\u00e7ek D\u00fcnya Senaryolar\u0131nda Uygulamalar<\/h2>\n
    YAZIM.D\u00dcZEN\u0130 fonksiyonunun pratikteki uygulamalar\u0131ndan baz\u0131lar\u0131:<\/p>\n
    Ki\u015fisel Veri D\u00fczenlemesi<\/h2>\n
    Veritaban\u0131n\u0131zdaki kay\u0131tl\u0131 ki\u015fi isimleri \u00e7e\u015fitli formatlarda olabilir. YAZIM.D\u00dcZEN\u0130 fonksiyonu bu isimleri d\u00fczenlemeyi sa\u011flar. \u00d6rne\u011fin:<\/p>\n\n\n\n\n
    Orjinal<\/th>\nD\u00fczeltilmi\u015f<\/th>\n<\/tr>\n
    MehMET demIR<\/td>\n=YAZIM.D\u00dcZEN\u0130(A2)<\/td>\n<\/tr>\n
    ayse KURT<\/td>\n=YAZIM.D\u00dcZEN\u0130(A3)<\/td>\n<\/tr>\n<\/table>\n
    Yukar\u0131daki A2 ve A3 h\u00fccreleri i\u00e7in YAZIM.D\u00dcZEN\u0130 fonksiyonu kullan\u0131l\u0131r ve isimler uygun bi\u00e7imde d\u00fczeltilir.<\/p>\n
    Mektup veya E-Posta i\u00e7in Adres Listesi Haz\u0131rlama<\/h2>\n
    Bir organizasyon, mektup veya e-posta g\u00f6nderimi i\u00e7in adres listesi haz\u0131rlarken adresleri d\u00fczenlemek isteyebilir:<\/p>\n
    YAZIM.D\u00dcZEN\u0130(D4)<\/code><\/pre>\n
    E\u011fer D4 h\u00fccresi “\u00e7\u0131nar sokak no:34 esenler\/\u0130STANBUL” yaz\u0131yorsa, fonksiyon “\u00c7\u0131nar Sokak No:34 Esenler\/\u0130stanbul” \u00e7\u0131kt\u0131s\u0131n\u0131 \u00fcretir, adres bilgilerini profesyonel bir g\u00f6r\u00fcn\u00fcme kavu\u015fturur.<\/p>\n
    YAZIM.D\u00dcZEN\u0130 fonksiyonu, metin d\u00fczenleme konusunda \u00e7e\u015fitli durumlar i\u00e7in kolayl\u0131k sa\u011flar, b\u00fcy\u00fck veri setleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken zaman tasarrufu sa\u011flamak ve veri sunumunu iyile\u015ftirmek i\u00e7in ideal bir ara\u00e7t\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Metin de\u011ferinin her s\u00f6zc\u00fc\u011f\u00fcn\u00fcn ilk harfini 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-15600","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de PROPER (YAZIM.D\u00dcZEN\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da PROPER (YAZIM.D\u00dcZEN\u0130) 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\/proper\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de PROPER (YAZIM.D\u00dcZEN\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da PROPER (YAZIM.D\u00dcZEN\u0130) 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\/proper\/\" \/>\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-02-25T16:34: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'de PROPER (YAZIM.D\u00dcZEN\u0130) 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\/proper\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/proper\/\",\"name\":\"Excel'de PROPER (YAZIM.D\u00dcZEN\u0130) 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-02-25T16:34:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PROPER (YAZIM.D\u00dcZEN\u0130) 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\/proper\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/proper\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/proper\/#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\":\"YAZIM.D\u00dcZEN\u0130\"}]},{\"@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 PROPER (YAZIM.D\u00dcZEN\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PROPER (YAZIM.D\u00dcZEN\u0130) 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\/proper\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PROPER (YAZIM.D\u00dcZEN\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PROPER (YAZIM.D\u00dcZEN\u0130) 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\/proper\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:34:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PROPER (YAZIM.D\u00dcZEN\u0130) 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\/proper\/","url":"https:\/\/functiontranslator.com\/tr\/proper\/","name":"Excel'de PROPER (YAZIM.D\u00dcZEN\u0130) 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-02-25T16:34:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PROPER (YAZIM.D\u00dcZEN\u0130) 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\/proper\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/proper\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/proper\/#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":"YAZIM.D\u00dcZEN\u0130"}]},{"@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\/15600","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=15600"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15600\/revisions"}],"predecessor-version":[{"id":26868,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15600\/revisions\/26868"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}