{"id":10923,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/hexabin\/"},"modified":"2021-02-25T17:20:41","modified_gmt":"2021-02-25T17:20:41","slug":"hex2bin","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/","title":{"rendered":"HEXABIN"},"content":{"rendered":"

A fun\u00e7\u00e3o HEXABIN, dispon\u00edvel tanto no Microsoft Excel quanto no Google Planilhas, \u00e9 projetada para converter um n\u00famero hexadecimal (base 16) em um n\u00famero bin\u00e1rio (base 2). Tal convers\u00e3o \u00e9 essencial em diversas \u00e1reas, incluindo ci\u00eancia da computa\u00e7\u00e3o, eletr\u00f4nica e processamento de dados.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe para utilizar a fun\u00e7\u00e3o HEXABIN \u00e9 a seguinte:<\/p>\n

HEXABIN(n\u00famero_hex, [n\u00famero_de_d\u00edgitos])<\/code><\/pre>\n
    \n
  • n\u00famero_hex<\/strong>: \u00c9 o n\u00famero hexadecimal que voc\u00ea deseja converter. Pode ser inserido diretamente como uma string (exemplo: “1A3”) ou atrav\u00e9s de uma refer\u00eancia a uma c\u00e9lula que contenha o valor hexadecimal.<\/li>\n
  • n\u00famero_de_d\u00edgitos<\/strong> (opcional): Define o n\u00famero m\u00ednimo de d\u00edgitos do n\u00famero bin\u00e1rio resultante. Se omitido, a fun\u00e7\u00e3o gera o n\u00famero bin\u00e1rio com o menor n\u00famero de d\u00edgitos poss\u00edvel que ainda representa completamente o valor hexadecimal original.<\/li>\n<\/ul>\n
    Exemplo 1:<\/p>\n
    =HEXABIN(\"1A3\") <\/code><\/pre>\n
    No exemplo acima, o resultado seria 110100011<\/strong>, referente ao n\u00famero hexadecimal 1A3 convertido para bin\u00e1rio.<\/p>\n
    Exemplo 2:<\/p>\n
    =HEXABIN(\"1A3\", 10)<\/code><\/pre>\n
    Aqui, o resultado \u00e9 0110100011<\/strong>. O n\u00famero bin\u00e1rio do hexadecimal 1A3 \u00e9 exibido com 10 d\u00edgitos, adicionando um zero \u00e0 esquerda para completar o n\u00famero de d\u00edgitos especificado.<\/p>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    A fun\u00e7\u00e3o HEXABIN oferece v\u00e1rias utilidades pr\u00e1ticas no ambiente profissional.<\/p>\n
    Convers\u00e3o de Endere\u00e7os MAC para Representa\u00e7\u00e3o Bin\u00e1ria<\/h2>\n
    Endere\u00e7os MAC, comumente usados em redes, s\u00e3o geralmente expressos em hexadecimal. Para determinadas an\u00e1lises, pode ser necess\u00e1rio convert\u00ea-los para a forma bin\u00e1ria.<\/p>\n\n\n\n
    Endere\u00e7o MAC<\/th>\nRepresenta\u00e7\u00e3o Bin\u00e1ria<\/th>\n<\/tr>\n
    A1:B2:C3<\/td>\n=HEXABIN(“A1”) & HEXABIN(“B2”) & HEXABIN(“C3”)<\/td>\n<\/tr>\n<\/table>\n
    Este exemplo ilustra a convers\u00e3o de cada segmento de um endere\u00e7o MAC de hexadecimal para bin\u00e1rio e a concatena\u00e7\u00e3o dos resultados para exibir o endere\u00e7o completo em bin\u00e1rio.<\/p>\n
    Desenvolvimento de Software e Depura\u00e7\u00e3o<\/h2>\n
    Desenvolvedores de software frequentemente necessitam converter dados hexadecimais, como c\u00f3digos de cores, para bin\u00e1rio com o objetivo de realizar an\u00e1lises ou manipula\u00e7\u00f5es dos dados.<\/p>\n
    Exemplo de Uso:<\/p>\n
    # Convers\u00e3o de c\u00f3digo de cor hexadecimal para bin\u00e1rio C\u00f3digo Hex: FFFFFF Bin\u00e1rio: =HEXABIN(\"FF\") & HEXABIN(\"FF\") & HEXABIN(\"FF\")<\/code><\/pre>\n
    Este exemplo demonstra a convers\u00e3o de um c\u00f3digo de cor hexadecimal “FFFFFF” (branco) para sua forma bin\u00e1ria, uma pr\u00e1tica comum em aplica\u00e7\u00f5es que manipulam informa\u00e7\u00f5es de cores a n\u00edvel de bit.<\/p>\n
    Em resumo, a fun\u00e7\u00e3o HEXABIN \u00e9 uma ferramenta importante em uma variedade de aplica\u00e7\u00f5es t\u00e9cnicas, oferecendo aos profissionais uma maneira eficiente de converter e analisar dados hexadecimais. Seu uso simplifica processos em campos como redes de computadores e desenvolvimento de software, entre outros.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Converte um n\u00famero hexadecimal em bin\u00e1rio<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[443],"tags":[],"class_list":["post-10923","post","type-post","status-publish","format-standard","hentry","category-engenharia"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o HEX2BIN (HEXABIN) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2BIN (HEXABIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\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\/pt-pt\/hex2bin\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o HEX2BIN (HEXABIN) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2BIN (HEXABIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:20:41+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o HEX2BIN (HEXABIN) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/\",\"name\":\"Fun\u00e7\u00e3o HEX2BIN (HEXABIN) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:20:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2BIN (HEXABIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Engenharia\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/engenharia\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HEXABIN\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o HEX2BIN (HEXABIN) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2BIN (HEXABIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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\/pt-pt\/hex2bin\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o HEX2BIN (HEXABIN) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2BIN (HEXABIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:20:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o HEX2BIN (HEXABIN) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/","url":"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/","name":"Fun\u00e7\u00e3o HEX2BIN (HEXABIN) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:20:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HEX2BIN (HEXABIN) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/hex2bin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Engenharia","item":"https:\/\/functiontranslator.com\/pt-pt\/engenharia\/"},{"@type":"ListItem","position":3,"name":"HEXABIN"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10923"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10923\/revisions"}],"predecessor-version":[{"id":25752,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10923\/revisions\/25752"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}