{"id":15588,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/ses\/"},"modified":"2021-02-25T16:33:36","modified_gmt":"2021-02-25T16:33:36","slug":"phonetic","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/phonetic\/","title":{"rendered":"SES"},"content":{"rendered":"

Excel ve Google E-Tablolar’da SES Fonksiyonunun Kullan\u0131m\u0131<\/h1>\n

PHONETIC<\/strong> veya baz\u0131 Excel s\u00fcr\u00fcmlerinde bulunan SES<\/strong> fonksiyonu, Asya dilleri (genellikle Japonca veya \u00c7ince) i\u00e7in metin i\u00e7indeki karakterlerin fonetik (ses) bile\u015fenlerini \u00e7\u0131kar\u0131r. Bu fonksiyon \u00f6zellikle metin i\u00e7erisindeki belirli karakterlerin fonetik temsillerini elde etmek i\u00e7in kullan\u0131l\u0131r. Bat\u0131 dillerinde genellikle bu fonksiyonun bir etkisi yoktur.<\/p>\n

Fonksiyonun S\u00f6zdizimi<\/h2>\n

SES fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

SES(ba\u015fvuru)<\/code><\/pre>\n
Burada “ba\u015fvuru”, fonetik temsilini almak istedi\u011finiz h\u00fccreyi ifade eder.<\/p>\n
Pratik Kullan\u0131mlar<\/h2>\n
SES fonksiyonun pratik kullan\u0131m\u0131na dair a\u015fa\u011f\u0131da iki \u00f6rnek verilmi\u015ftir:<\/p>\n
\u00d6rnek 1: \u0130leti\u015fim Listesi D\u00fczenleme<\/h2>\n
Diyelim ki, bir \u015firkette \u00e7al\u0131\u015f\u0131yorsunuz ve Asya k\u00f6kenli i\u015f ortaklar\u0131n\u0131z\u0131n isimlerinin fonetik temsillerini i\u00e7eren bir ileti\u015fim listesi olu\u015fturman\u0131z gerekiyor. Excel veya Google E-Tablolar’da bu isimleri A s\u00fctununa girip, B s\u00fctununda SES fonksiyonu ile fonetik temsillerini h\u0131zl\u0131ca olu\u015fturabilirsiniz:<\/p>\n
A s\u00fctunu B s\u00fctunu \u674e\u5c0f\u9f8d =SES(A1) \u5f20\u4f1f =SES(A2)<\/code><\/pre>\n
Bu, isimleri latin alfabesi kullan\u0131lmadan okuma imkan\u0131 sa\u011flar ve telefon g\u00f6r\u00fc\u015fmeleri veya toplant\u0131lar s\u0131ras\u0131nda do\u011fru telaffuzlar i\u00e7in rehber olu\u015fturur.<\/p>\n
\u00d6rnek 2: Veri Temizleme ve D\u00fczenleme<\/h2>\n
\u00c7inceden \u00e7eviri yapan bir firma i\u00e7in \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcnelim. Metinlerdeki karakterlerin do\u011fru fonetik temsillerini \u00e7\u0131karmak, do\u011fru tonlar\u0131 ve aksanlar\u0131 belirlemek \u00f6nemlidir. \u00c7al\u0131\u015fma sayfan\u0131zda, \u00e7eviri yap\u0131lacak \u00c7ince metinler A s\u00fctunu \u00fczerinde yer al\u0131yormu\u015f gibi d\u00fc\u015f\u00fcnelim:<\/p>\n
A s\u00fctunu B s\u00fctunu \u94f6\u884c =SES(A1) \u8d85\u5e02 =SES(A2)<\/code><\/pre>\n
Buradaki SES form\u00fcl\u00fc, yaz\u0131lacak metnin do\u011fru aksan ve tonlamalarla \u00e7evrilmesinde yard\u0131mc\u0131 olur, b\u00f6ylece daha nitelikli ve do\u011fru \u00e7eviriler yap\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n
Uyumluluk a\u00e7\u0131s\u0131ndan belirtmek gerekir ki SES fonksiyonu sadece Excel\u2019in belirli versiyonlar\u0131nda ve Google E-Tablolar\u2019da Asya dilleri i\u00e7in \u00e7al\u0131\u015f\u0131r ve t\u00fcm dillerde veya s\u00fcr\u00fcmlerde kullan\u0131lamaz. Excel versiyonunuzda SES fonksiyonunun mevcut olup olmad\u0131\u011f\u0131n\u0131 kontrol ediniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
Metin dizesinden ses (furigana) karakterlerini ay\u0131klar<\/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-15588","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de PHONETIC (SES) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da PHONETIC (SES) 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\/phonetic\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de PHONETIC (SES) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da PHONETIC (SES) 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\/phonetic\/\" \/>\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:33:36+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 PHONETIC (SES) 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\/phonetic\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/phonetic\/\",\"name\":\"Excel'de PHONETIC (SES) 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:33:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PHONETIC (SES) 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\/phonetic\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/phonetic\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/phonetic\/#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\":\"SES\"}]},{\"@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 PHONETIC (SES) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PHONETIC (SES) 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\/phonetic\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PHONETIC (SES) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PHONETIC (SES) 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\/phonetic\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PHONETIC (SES) 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\/phonetic\/","url":"https:\/\/functiontranslator.com\/tr\/phonetic\/","name":"Excel'de PHONETIC (SES) 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:33:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PHONETIC (SES) 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\/phonetic\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/phonetic\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/phonetic\/#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":"SES"}]},{"@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\/15588","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=15588"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15588\/revisions"}],"predecessor-version":[{"id":26856,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15588\/revisions\/26856"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}