{"id":15506,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/jis\/"},"modified":"2021-02-25T16:30:12","modified_gmt":"2021-02-25T16:30:12","slug":"jis","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/jis\/","title":{"rendered":"JIS"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, i\u015f, e\u011fitim ve ki\u015fisel veri analizi gibi \u00e7e\u015fitli alanlarda geni\u015f kullan\u0131m olanaklar\u0131 sunan elektronik tablo uygulamalar\u0131d\u0131r. Bu ara\u00e7lar, \u00e7e\u015fitli fonksiyonlar vas\u0131tas\u0131yla kullan\u0131c\u0131lar\u0131n veri i\u015fleme s\u00fcre\u00e7lerini kolayla\u015ft\u0131r\u0131r. Bu yaz\u0131da, JIS fonksiyonunun kullan\u0131m\u0131n\u0131 ve bu fonksiyonun pratik uygulamalar\u0131n\u0131 inceleyece\u011fiz.<\/p>\n<h2>JIS Fonksiyonuna Genel Bak\u0131\u015f<\/h2>\n<p>JIS fonksiyonu, verilen karakter dizisindeki t\u00fcm Halfwidth (tek geni\u015flik) ve Fullwidth (\u00e7ift geni\u015flik) karakterleri, uygun Japon End\u00fcstri Standartlar\u0131na (JIS) d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Japonca metin i\u015fleme esnas\u0131nda bu d\u00f6n\u00fc\u015f\u00fcm olduk\u00e7a \u00f6nemlidir zira Japon yaz\u0131m\u0131 bu iki karakter stilini i\u00e7erir ve do\u011fruluk, okunabilirlik veya belirli format standartlar\u0131na uygunluk sa\u011flamak i\u00e7in bu d\u00f6n\u00fc\u015f\u00fcmler gereklidir.<\/p>\n<p><b>S\u00f6zdizimi:<\/b><\/p>\n<pre><code>JIS(metin)<\/code><\/pre>\n<p><b>Parametreler:<\/b><\/p>\n<ul>\n<li><b>metin:<\/b> D\u00f6n\u00fc\u015ft\u00fcr\u00fclecek metin. Bu metin bir string ifadesi olabilir veya metin i\u00e7eren bir h\u00fccre referans\u0131 olabilir.<\/li>\n<\/ul>\n<h2>Uygulama \u00d6rnekleri<\/h2>\n<h2>\u00d6rnek 1: Temel Tek Geni\u015flikten \u00c7ift Geni\u015fli\u011fe D\u00f6n\u00fc\u015f\u00fcm<\/h2>\n<p>\u00d6rne\u011fin, bir restoran men\u00fcs\u00fcn\u00fcn Japonca karakter i\u00e7eren \u00f6\u011felerinin t\u00fcm\u00fcn\u00fcn \u00e7ift geni\u015flikte olmas\u0131n\u0131 istiyorsunuz. Men\u00fcdeki bir \u00f6\u011fenin ad\u0131 tek geni\u015flikte yaz\u0131lm\u0131\u015f olabilir ve bunu \u00e7ift geni\u015flik format\u0131na \u00e7evirmeniz gerekebilir.<\/p>\n<p><b>Problem:<\/b> &#8220;\uff7d\uff7c&#8221; tek geni\u015flikte (Halfwidth) olan sushi kelimesini \u00e7ift geni\u015flikte (Fullwidth) d\u00f6n\u00fc\u015ft\u00fcrmek.<\/p>\n<pre><code> =JIS(\"\uff7d\uff7c\") <\/code><\/pre>\n<p>Bu form\u00fcl, &#8220;\u30b9\u30b7&#8221; olarak sonu\u00e7 verecektir ki bu da sushi kelimesinin \u00e7ift geni\u015flikteki Japonca kar\u015f\u0131l\u0131\u011f\u0131d\u0131r.<\/p>\n<h2>\u00d6rnek 2: Veri Temizleme ve Standardizasyon<\/h2>\n<p>Bir veri seti \u00fczerinde \u00e7al\u0131\u015f\u0131rken, veri setinizdeki Japonca karakterlerin format\u0131n\u0131n tutarl\u0131 olmas\u0131 gerekiyor. Farkl\u0131 veri kaynaklar\u0131ndan gelen bilgiler kimi zaman tek geni\u015flik kimi zaman \u00e7ift geni\u015flik karakterler i\u00e7erebilir. Siz, t\u00fcm verilerin JIS standartlar\u0131na uygun \u00e7ift geni\u015flikte olmas\u0131n\u0131 isteyebilirsiniz.<\/p>\n<p><b>Problem:<\/b> A1 h\u00fccresinde &#8220;\uff83\uff7d\uff84&#8221; (test) kelimesi tek geni\u015flikte yaz\u0131lm\u0131\u015f ve bunu \u00e7ift geni\u015fli\u011fe d\u00f6n\u00fc\u015ft\u00fcrmek istiyorsunuz.<\/p>\n<pre><code> =JIS(A1) <\/code><\/pre>\n<p>Form\u00fcl, A1 h\u00fccresindeki metni &#8220;\u30c6\u30b9\u30c8&#8221; olarak \u00e7ift geni\u015flikte d\u00f6n\u00fc\u015ft\u00fcrecektir. Bu, t\u00fcm veri seti \u00fczerindeki Japonca metinleri standart bir forma sokman\u0131z\u0131 sa\u011flar.<\/p>\n<p>Bu \u00f6rnekler, JIS fonksiyonunun Japonca metin i\u015fleme g\u00f6revlerinde ne kadar yararl\u0131 ve \u00f6nemli oldu\u011funu g\u00f6stermektedir. \u0130ster belgenin okunabilirli\u011fini art\u0131r\u0131n, ister veriyi temizleyin veya standartla\u015ft\u0131r\u0131n, JIS fonksiyonu Japonca karakterlerle \u00e7al\u0131\u015fman\u0131zda b\u00fcy\u00fck bir yard\u0131mc\u0131 olacakt\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dizedeki yar\u0131m geni\u015flikteki (tek baytl\u0131) karakterleri tam geni\u015flikteki (\u00e7ift baytl\u0131) karakterlerle de\u011fi\u015ftirir<\/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-15506","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 JIS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da JIS 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\/jis\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de JIS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da JIS 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\/jis\/\" \/>\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:30:12+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 JIS 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\/jis\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/jis\/\",\"name\":\"Excel'de JIS 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:30:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da JIS 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\/jis\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/jis\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/jis\/#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\":\"JIS\"}]},{\"@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 JIS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da JIS 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\/jis\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de JIS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da JIS 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\/jis\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:30:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de JIS 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\/jis\/","url":"https:\/\/functiontranslator.com\/tr\/jis\/","name":"Excel'de JIS 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:30:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da JIS 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\/jis\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/jis\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/jis\/#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":"JIS"}]},{"@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\/15506","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=15506"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15506\/revisions"}],"predecessor-version":[{"id":26774,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15506\/revisions\/26774"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}