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

Description de la fonction UNICODE<\/h2>\n

La fonction UNICODE<\/strong> dans Microsoft Excel et Google Sheets est utilis\u00e9e pour obtenir le num\u00e9ro de point de code Unicode du premier caract\u00e8re d’une cha\u00eene de texte. Chaque caract\u00e8re dans l’ensemble Unicode est unique et est identifi\u00e9 par ce num\u00e9ro de point de code.<\/p>\n

Syntaxe de la fonction :<\/p>\n

 UNICODE(texte)<\/code> <\/pre>\n
O\u00f9 texte<\/em> est le caract\u00e8re ou la cha\u00eene de texte pour lequel vous souhaitez d\u00e9terminer le num\u00e9ro du point de code Unicode du premier caract\u00e8re.<\/p>\n
Exemples de syntaxe<\/h2>\n
    \n
  • Pour obtenir le point de code Unicode de ‘A’, saisissez :<\/li>\n
     =UNICODE(\"A\")<\/code> <\/pre>\n
  • R\u00e9sultat : 65<\/li>\n
  • Pour un caract\u00e8re non anglais tel que ‘\u00e9’, utilisez :<\/li>\n
     =UNICODE(\"\u00e9\")<\/code> <\/pre>\n
  • R\u00e9sultat : 233<\/li>\n
  • Si la cha\u00eene contient plusieurs caract\u00e8res, le point de code du premier caract\u00e8re sera retourn\u00e9. Par exemple :<\/li>\n
     =UNICODE(\"abc\")<\/code> <\/pre>\n
  • R\u00e9sultat : 97 (point de code de ‘a’)<\/li>\n<\/ul>\n
    Applications pratiques de la fonction<\/h2>\n
    Voici quelques usages courants de la fonction UNICODE :<\/p>\n
    Tri alphab\u00e9tique personnalis\u00e9<\/h2>\n
    Pour trier une liste de mots issus de diverses langues en fonction du premier caract\u00e8re en utilisant son point de code Unicode, cette fonction s’av\u00e8re particuli\u00e8rement utile, notamment dans les langues o\u00f9 l’ordre alphab\u00e9tique standard n’est pas applicable.<\/p>\n\n\n\n\n\n\n
    Mot<\/td>\nFormule<\/td>\nCode Unicode<\/td>\n<\/tr>\n
    \u00eatre<\/td>\n=UNICODE(\"\u00eatre\")<\/code><\/td>\n234<\/td>\n<\/tr>\n
    apple<\/td>\n=UNICODE(\"apple\")<\/code><\/td>\n97<\/td>\n<\/tr>\n
    haus<\/td>\n=UNICODE(\"haus\")<\/code><\/td>\n104<\/td>\n<\/tr>\n
    \u00c1rbol<\/td>\n=UNICODE(\"\u00c1rbol\")<\/code><\/td>\n193<\/td>\n<\/tr>\n<\/table>\n
    Vous pouvez alors trier la liste par la colonne ‘Code Unicode’ pour obtenir un ordre personnalis\u00e9.<\/p>\n
    Validation de l’entr\u00e9e de donn\u00e9es<\/h2>\n
    Pour un formulaire o\u00f9 les utilisateurs doivent entrer un caract\u00e8re sp\u00e9cial, la fonction UNICODE permet de v\u00e9rifier la correspondance du caract\u00e8re entr\u00e9 avec le caract\u00e8re sp\u00e9cial attendu.<\/p>\n
     =SI(UNICODE(caract\u00e8re_entr\u00e9) = 937, \"Caract\u00e8re valide\", \"Caract\u00e8re invalide\")<\/code> <\/pre>\n
    Dans cet exemple, o\u00f9 ‘\u03a9’ a un code Unicode de 937, cette formule confirme que l’utilisateur a bien entr\u00e9 le caract\u00e8re attendu.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le nombre (point de code) qui correspond au premier caract\u00e8re du 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-6826","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction UNICODE dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction UNICODE 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\/unicode\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction UNICODE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction UNICODE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/unicode\/\" \/>\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:15:46+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction UNICODE 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\/unicode\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/unicode\/\",\"name\":\"Fonction UNICODE 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:15:46+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction UNICODE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/unicode\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/unicode\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/unicode\/#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\":\"UNICODE\"}]},{\"@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 UNICODE dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction UNICODE 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\/unicode\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction UNICODE dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction UNICODE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/unicode\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:46+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction UNICODE 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\/unicode\/","url":"https:\/\/functiontranslator.com\/fr\/unicode\/","name":"Fonction UNICODE 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:15:46+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction UNICODE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/unicode\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/unicode\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/unicode\/#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":"UNICODE"}]},{"@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\/6826","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=6826"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6826\/revisions"}],"predecessor-version":[{"id":29835,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6826\/revisions\/29835"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}