{"id":15446,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/hex2bin\/"},"modified":"2021-02-25T16:27:58","modified_gmt":"2021-02-25T16:27:58","slug":"hex2bin","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/hex2bin\/","title":{"rendered":"HEX2BIN"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri analizi ve i\u015fleme konusunda m\u00fckemmel ara\u00e7lard\u0131r. Bu platformlarda bir\u00e7ok farkl\u0131 fonksiyon yer almakta olup, bu yaz\u0131da HEX2BIN fonksiyonunun kullan\u0131m\u0131 detayl\u0131 bir \u015fekilde incelenecektir. HEX2BIN fonksiyonu, onalt\u0131l\u0131k (hexadecimal) say\u0131 sisteminden ikilik (binary) say\u0131 sistemine \u00e7evrim yapar ki bu, bilgisayar bilimleri ve m\u00fchendislik gibi alanlarda olduk\u00e7a i\u015flevseldir.<\/p>\n

GENEL S\u00d6ZD\u0130Z\u0130M\u0130<\/h2>\n

HEX2BIN fonksiyonunun genel s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

HEX2BIN(hex_number, [places])<\/code><\/pre>\n
    \n
  • hex_number<\/strong>: Onalt\u0131l\u0131k say\u0131 sistemine ait say\u0131. Bu, metin \u015feklinde (\u00f6rne\u011fin “1A”) veya do\u011frudan onalt\u0131l\u0131k bir say\u0131 olarak (\u00f6rne\u011fin 26 i\u00e7in 1A) girilebilir.<\/li>\n
  • places<\/strong>: (\u0130ste\u011fe ba\u011fl\u0131) Sonu\u00e7 olarak g\u00f6sterilecek minimum bit say\u0131s\u0131. Bu parametre belirtilmezse veya \u00e7ok d\u00fc\u015f\u00fck bir de\u011fer girilirse, fonksiyon otomatik olarak gerekli bit say\u0131s\u0131n\u0131 hesaplar.<\/li>\n<\/ul>\n
    \u00d6RNEKLER<\/h2>\n
    A\u015fa\u011f\u0131da, HEX2BIN fonksiyonunun kullan\u0131m\u0131na dair birka\u00e7 \u00f6rnek bulunmaktad\u0131r:<\/p>\n
    HEX2BIN(\"1A\") Sonu\u00e7: 11010<\/code><\/pre>\n
    HEX2BIN(\"1A\", 8) Sonu\u00e7: 00011010<\/code><\/pre>\n
    Bu \u00f6rneklerde, “1A” onalt\u0131l\u0131k say\u0131s\u0131n\u0131n ikilik say\u0131 sisteminde nas\u0131l temsil edilece\u011fi g\u00f6r\u00fclmektedir. \u0130kinci \u00f6rnekte places<\/code> arg\u00fcman\u0131 sayesinde sonu\u00e7 8 bit olarak g\u00f6sterilmi\u015ftir.<\/p>\n
    UYGULAMALI PROBLEMLER<\/h2>\n
    \u015eimdi, HEX2BIN fonksiyonunun pratikte nas\u0131l kullan\u0131labilece\u011fi \u00fczerine birka\u00e7 senaryo ele alal\u0131m:<\/p>\n
    Problem 1: Veri Analizi<\/h2>\n
    Varsayal\u0131m ki, bir a\u011f g\u00fcvenlik sistemi \u00e7er\u00e7evesinde log dosyalar\u0131 onalt\u0131l\u0131k formatda saklanmaktad\u0131r ve bu loglar\u0131n ikilik sistemde analiz edilmesi gerekiyor. Bu durumda HEX2BIN fonksiyonu kullan\u0131labilir:<\/p>\n
    Veri: \"ABCD\" (log dosyas\u0131ndan al\u0131nan onalt\u0131l\u0131k veri) Formula: =HEX2BIN(\"ABCD\", 16) Sonu\u00e7: 1010101111001101<\/code><\/pre>\n
    Bu sonu\u00e7 ile log dosyalar\u0131 daha detayl\u0131 incelenebilir ve veriler daha efektif \u015fekilde i\u015flenebilir.<\/p>\n
    Problem 2: E\u011fitim Materyali Haz\u0131rlama<\/h2>\n
    Bir \u00f6\u011fretmen, bilgisayar bilimleri dersinde onalt\u0131l\u0131k ve ikilik say\u0131 sistemlerinin farkl\u0131l\u0131klar\u0131n\u0131 \u00f6\u011frencilere anlatmak i\u00e7in HEX2BIN fonksiyonunu kullanarak \u00f6rnekler haz\u0131rlayabilir:<\/p>\n
    \u00d6rnek: \"F\" onalt\u0131l\u0131k say\u0131s\u0131 Form\u00fcl: =HEX2BIN(\"F\", 4) Sonu\u00e7: 1111<\/code><\/pre>\n
    Bu basit d\u00f6n\u00fc\u015f\u00fcm sayesinde \u00f6\u011frenciler onalt\u0131l\u0131k say\u0131n\u0131n ikilik temsiline kolayl\u0131kla vak\u0131f olabilir ve iki sistem aras\u0131ndaki ili\u015fkiyi daha iyi kavrayabilirler.<\/p>\n
    Yukar\u0131daki bilgiler ve \u00f6rnekler, HEX2BIN fonksiyonunun kullan\u0131m\u0131n\u0131 anlaman\u0131zda faydal\u0131 olacakt\u0131r ve bu fonksiyon, farkl\u0131 say\u0131 sistemleri aras\u0131nda d\u00f6n\u00fc\u015f\u00fcm yap\u0131lmas\u0131n\u0131 hem e\u011fitici hem de pratik k\u0131lar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Onalt\u0131l\u0131 bir say\u0131y\u0131 ikiliye d\u00f6n\u00fc\u015ft\u00fcr\u00fcr<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[583],"tags":[],"class_list":["post-15446","post","type-post","status-publish","format-standard","hentry","category-muhendislik"],"acf":[],"yoast_head":"\nExcel'de HEX2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da HEX2BIN 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\/hex2bin\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de HEX2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da HEX2BIN 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\/hex2bin\/\" \/>\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:27:58+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 HEX2BIN 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\/hex2bin\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/hex2bin\/\",\"name\":\"Excel'de HEX2BIN 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:27:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da HEX2BIN 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\/hex2bin\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/hex2bin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/hex2bin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"M\u00fchendislik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/muhendislik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HEX2BIN\"}]},{\"@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 HEX2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da HEX2BIN 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\/hex2bin\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de HEX2BIN Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da HEX2BIN 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\/hex2bin\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:27:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de HEX2BIN 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\/hex2bin\/","url":"https:\/\/functiontranslator.com\/tr\/hex2bin\/","name":"Excel'de HEX2BIN 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:27:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da HEX2BIN 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\/hex2bin\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/hex2bin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/hex2bin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"M\u00fchendislik","item":"https:\/\/functiontranslator.com\/tr\/muhendislik\/"},{"@type":"ListItem","position":3,"name":"HEX2BIN"}]},{"@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\/15446","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=15446"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15446\/revisions"}],"predecessor-version":[{"id":26714,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15446\/revisions\/26714"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}