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

La fonction CODE<\/code> dans Microsoft Excel et Google Sheets est essentielle pour obtenir le code ASCII d\u2019un caract\u00e8re sp\u00e9cifique. Ce code est un num\u00e9ro unique qui identifie le caract\u00e8re dans la table ASCII. Comprendre ces codes est crucial lorsqu\u2019on travaille avec des donn\u00e9es textuelles et pour effectuer des analyses d\u00e9taill\u00e9es.<\/p>\n

Syntaxe<\/h2>\n

La syntaxe pour la fonction CODE<\/code> est simple :<\/p>\n

=CODE(texte)<\/code><\/pre>\n
Ici, texte<\/code> d\u00e9signe le caract\u00e8re ou la cha\u00eene de caract\u00e8res dont vous voulez obtenir le code ASCII du premier caract\u00e8re.<\/p>\n
Exemple :<\/strong><\/p>\n
=CODE(\"A\")<\/code><\/pre>\n
Cet exemple renverra 65<\/code>, qui est le code ASCII du caract\u00e8re ‘A’.<\/p>\n
Applications pratiques<\/h2>\n
Voici quelques utilisations pratiques de la fonction CODE<\/code> pour r\u00e9soudre des probl\u00e8mes courants.<\/p>\n
Trier des caract\u00e8res selon leur code ASCII<\/h2>\n
Supposez que vous ayez une liste de caract\u00e8res et que vous souhaitiez les classer selon leur code ASCII. Vous pouvez le faire de la mani\u00e8re suivante :<\/p>\n
=TRIE(SI(ROW(indirect(\"1:\"&LEN(A1))),CODE(MID(A1, ROW(indirect(\"1:\"&LEN(A1))), 1))))<\/code><\/pre>\n
Cette formule complexe trie chaque caract\u00e8re de la cha\u00eene pr\u00e9sente dans la cellule A1 selon son code ASCII.<\/p>\n\n\n\n\n
Cellule<\/th>\nFormule<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
A1<\/td>\nabca<\/td>\n–<\/td>\n<\/tr>\n
B1<\/td>\n=TRIE(SI(ROW(indirect(\u00ab\u00a01:\u00a0\u00bb&LEN(A1))),CODE(MID(A1, ROW(indirect(\u00ab\u00a01:\u00a0\u00bb&LEN(A1))), 1))))<\/td>\n97, 98, 99, 97<\/td>\n<\/tr>\n<\/table>\n
D\u00e9tection d’une entr\u00e9e non standard<\/h2>\n
Imaginez que vous devez vous assurer que les cha\u00eenes entr\u00e9es dans une colonne sont uniquement des majuscules ASCII standards. La fonction CODE<\/code> peut \u00eatre utilis\u00e9e ainsi :<\/p>\n
=SI(ET(CODE(CHAR(A1)) >= 65, CODE(CHAR(A1)) <= 90), \"Valide\", \"Non Valide\")<\/code><\/pre>\n
Cette formule contr\u00f4le si le code ASCII de chaque caract\u00e8re dans A1 se situe entre 65 (A) et 90 (Z), validant uniquement les lettres majuscules standards.<\/p>\n\n\n\n\n\n
Cellule<\/th>\nFormule<\/th>\nV\u00e9rification<\/th>\n<\/tr>\n
A1<\/td>\nBONJOUR<\/td>\nValide<\/td>\n<\/tr>\n
A2<\/td>\nbonjour<\/td>\nNon Valide<\/td>\n<\/tr>\n
B1<\/td>\n=SI(ET(CODE(CHAR(A1)) >= 65, CODE(CHAR(A1)) <= 90), \u00ab\u00a0Valide\u00a0\u00bb, \u00ab\u00a0Non Valide\u00a0\u00bb)<\/td>\n–<\/td>\n<\/tr>\n<\/table>\n
\u00c0 travers ces exemples, il est \u00e9vident que la fonction CODE<\/code> est extr\u00eamement utile dans divers contextes pour une manipulation pr\u00e9cise et efficace des cha\u00eenes de caract\u00e8res.<\/p>\n","protected":false},"excerpt":{"rendered":"
Renvoie le num\u00e9Ro de code du pRemieR caRact\u00e8Re d\u2019une cha\u00eene de texte<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[314],"tags":[],"class_list":["post-6441","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction CODE dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CODE 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\/code\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CODE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CODE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/code\/\" \/>\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:03: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 CODE 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\/code\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/code\/\",\"name\":\"Fonction CODE 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:03:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CODE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/code\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/code\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/code\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Texte\",\"item\":\"https:\/\/functiontranslator.com\/fr\/texte\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CODE\"}]},{\"@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 CODE dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CODE 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\/code\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CODE dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CODE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/code\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CODE 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\/code\/","url":"https:\/\/functiontranslator.com\/fr\/code\/","name":"Fonction CODE 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:03:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CODE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/code\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/code\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/code\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Texte","item":"https:\/\/functiontranslator.com\/fr\/texte\/"},{"@type":"ListItem","position":3,"name":"CODE"}]},{"@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\/6441","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=6441"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6441\/revisions"}],"predecessor-version":[{"id":29453,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6441\/revisions\/29453"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}