{"id":6576,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/hexbin\/"},"modified":"2021-02-26T08:07:15","modified_gmt":"2021-02-26T08:07:15","slug":"hex2bin","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/hex2bin\/","title":{"rendered":"HEXBIN"},"content":{"rendered":"

Description et Syntaxe<\/h2>\n

La fonction HEX2BIN dans Excel permet de convertir un nombre hexad\u00e9cimal en un nombre binaire, ce qui est particuli\u00e8rement utile dans les domaines de l’informatique et de l’\u00e9lectronique num\u00e9rique. Dans Google Sheets, cette fonction est \u00e9galement appel\u00e9e HEX2BIN.<\/p>\n

Voici comment utiliser la syntaxe de la fonction HEX2BIN :<\/p>\n

HEX2BIN(nombre_hex, [places])<\/code><\/pre>\n
    \n
  • nombre_hex<\/code> : La cha\u00eene de caract\u00e8res qui repr\u00e9sente le nombre hexad\u00e9cimal \u00e0 convertir en binaire. La cha\u00eene doit \u00eatre valide (par exemple, \u00ab\u00a01A\u00a0\u00bb, \u00ab\u00a03B5\u00a0\u00bb).<\/li>\n
  • places<\/code> : Optionnel. C’est le nombre de bits minimum que doit contenir le r\u00e9sultat final. Si le nombre sp\u00e9cifi\u00e9 est sup\u00e9rieur au minimum n\u00e9cessaire pour repr\u00e9senter le nombre en binaire, des z\u00e9ros seront ajout\u00e9s \u00e0 gauche pour combler la diff\u00e9rence.<\/li>\n<\/ul>\n
    Exemples Pratiques<\/h2>\n
    Examinons quelques exemples de l’utilisation de la fonction HEX2BIN.<\/p>\n
    Transformation d’un nombre hexad\u00e9cimal en binaire<\/h2>\n
    Pour convertir le nombre hexad\u00e9cimal \u00ab\u00a01A3\u00a0\u00bb en binaire :<\/p>\n
    =HEX2BIN(\"1A3\")<\/code><\/pre>\n
    Cette formule renvoie \u00ab\u00a0110100011\u00a0\u00bb, qui est la repr\u00e9sentation binaire du nombre \u00ab\u00a01A3\u00a0\u00bb.<\/p>\n
    Utilisation de l’argument ‘places’<\/h2>\n
    Si vous souhaitez que le r\u00e9sultat contienne au moins 12 bits, vous pouvez sp\u00e9cifier cela \u00e0 l’aide de l’argument facultatif :<\/p>\n
    =HEX2BIN(\"1A3\", 12)<\/code><\/pre>\n
    Ceci donnera \u00ab\u00a00000110100011\u00a0\u00bb, ajoutant ainsi des z\u00e9ros \u00e0 gauche pour atteindre un total de 12 bits.<\/p>\n
    Applications Pratiques<\/h2>\n
    La fonction HEX2BIN peut \u00eatre utile dans plusieurs contextes :<\/p>\n
    D\u00e9bogage en programmation mat\u00e9rielle<\/h2>\n
    Les d\u00e9veloppeurs qui travaillent sur des logiciels de bas niveau ou du mat\u00e9riel informatique peuvent utiliser HEX2BIN pour d\u00e9boguer et v\u00e9rifier les valeurs stock\u00e9es en m\u00e9moire, souvent affich\u00e9es sous forme hexad\u00e9cimale, en les comparant \u00e0 leurs \u00e9quivalents binaires attendus.<\/p>\n
    \u00c9ducation et enseignement<\/h2>\n
    Les enseignants en arithm\u00e9tique binaire ou en informatique peuvent b\u00e9n\u00e9ficier de l’utilisation de HEX2BIN pour cr\u00e9er des supports p\u00e9dagogiques et illustrer la conversion des nombres d’un format \u00e0 un autre, facilitant ainsi la compr\u00e9hension des \u00e9tudiants.<\/p>\n
    L’utilisation de HEX2BIN est intuitive et s’applique de mani\u00e8re similaire \u00e0 Excel et Google Sheets, rendant ces enseignements pr\u00e9cieux quelle que soit la plateforme utilis\u00e9e.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Convertit un nombre hexad\u00e9Cimal en nombre binaire<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[316],"tags":[],"class_list":["post-6576","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction HEX2BIN (HEXBIN) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction HEX2BIN (HEXBIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/hex2bin\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction HEX2BIN (HEXBIN) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction HEX2BIN (HEXBIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/hex2bin\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:07:15+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction HEX2BIN (HEXBIN) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/hex2bin\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/hex2bin\/\",\"name\":\"Fonction HEX2BIN (HEXBIN) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:07:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction HEX2BIN (HEXBIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/hex2bin\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/hex2bin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/hex2bin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ing\u00e9nierie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/ingenierie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"HEXBIN\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction HEX2BIN (HEXBIN) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction HEX2BIN (HEXBIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/hex2bin\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction HEX2BIN (HEXBIN) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction HEX2BIN (HEXBIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/hex2bin\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:07:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction HEX2BIN (HEXBIN) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/hex2bin\/","url":"https:\/\/functiontranslator.com\/fr\/hex2bin\/","name":"Fonction HEX2BIN (HEXBIN) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:07:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction HEX2BIN (HEXBIN) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/hex2bin\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/hex2bin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/hex2bin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Ing\u00e9nierie","item":"https:\/\/functiontranslator.com\/fr\/ingenierie\/"},{"@type":"ListItem","position":3,"name":"HEXBIN"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6576"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6576\/revisions"}],"predecessor-version":[{"id":29587,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6576\/revisions\/29587"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}