{"id":6825,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/unicar\/"},"modified":"2021-02-26T08:15:45","modified_gmt":"2021-02-26T08:15:45","slug":"unichar","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/unichar\/","title":{"rendered":"UNICAR"},"content":{"rendered":"<p>La fonction UNICHAR dans Microsoft Excel et UNICAR dans Google Sheets est cruciale pour g\u00e9n\u00e9rer le caract\u00e8re correspondant \u00e0 un code Unicode sp\u00e9cifique. Cette fonction est tr\u00e8s utile pour afficher des symboles ou des caract\u00e8res sp\u00e9ciaux qui ne sont pas directement accessibles via le clavier.<\/p>\n<h2>Pr\u00e9sentation et Syntaxe<\/h2>\n<p>La syntaxe de cette fonction est simple et requiert un seul argument :<\/p>\n<ul>\n<li><strong>Excel<\/strong>: <code>UNICHAR(num\u00e9ro)<\/code><\/li>\n<li><strong>Google Sheets<\/strong>: <code>UNICAR(num\u00e9ro)<\/code><\/li>\n<\/ul>\n<p>Le <code>num\u00e9ro<\/code> est le code Unicode du caract\u00e8re que vous souhaitez obtenir. Unicode est une norme internationale qui permet de coder du texte pour presque tous les syst\u00e8mes d&rsquo;\u00e9criture du monde.<\/p>\n<pre><code>Exemple : Dans Excel : =UNICHAR(9731) retourne le symbole de flocon de neige \u2744. Dans Google Sheets : =UNICAR(9731) retourne le m\u00eame symbole \u2744.<\/code><\/pre>\n<h2>Applications pratiques<\/h2>\n<p>Cette fonction peut \u00eatre extr\u00eamement utile dans divers contextes, que ce soit pour embellir visuellement des donn\u00e9es ou pour des op\u00e9rations n\u00e9cessitant l&rsquo;identification de caract\u00e8res sp\u00e9cifiques.<\/p>\n<h2>Exemple 1 : Cr\u00e9ation d&rsquo;une \u00c9chelle de Notation Visuelle<\/h2>\n<p>Supposez que vous souhaitiez \u00e9tablir un syst\u00e8me de notation visuel pour un rapport de performance, en utilisant des \u00e9toiles plut\u00f4t que des chiffres :<\/p>\n<pre><code>=REPT(UNICHAR(9733), 3) donnera comme r\u00e9sultat \u2605\u2605\u2605 pour une note de 3 sur 5.<\/code><\/pre>\n<p>Cette formule utilise la fonction <code>REPT<\/code> pour r\u00e9p\u00e9ter l&rsquo;\u00e9toile, obtenue via <code>UNICHAR(9733)<\/code>, le nombre de fois indiqu\u00e9, ici 3.<\/p>\n<table>\n<tr>\n<th>Note<\/th>\n<th>R\u00e9presentation<\/th>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>=REPT(UNICHAR(9733), 1)<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>=REPT(UNICHAR(9733), 2)<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>=REPT(UNICHAR(9733), 3)<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>=REPT(UNICHAR(9733), 4)<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>=REPT(UNICHAR(9733), 5)<\/td>\n<\/tr>\n<\/table>\n<h2>Exemple 2 : Encodage de Donn\u00e9es<\/h2>\n<p>Imaginez que vous traitiez un ensemble de donn\u00e9es avec diff\u00e9rents statuts pour des commandes : Completed, Pending et Canceled. Vous d\u00e9cidez d&rsquo;associer un symbole \u00e0 chaque statut :<\/p>\n<pre><code>Dans Excel ou Google Sheets: S\u00e9lectionnez une cellule et utilisez l'une des formules suivantes selon le statut : - Pour \"Completed\" : =CONCATENATE(\"Completed \", UNICHAR(10004)) - Pour \"Pending\" : =CONCATENATE(\"Pending \", UNICHAR(9203)) - Pour \"Canceled\" : =CONCATENATE(\"Canceled \", UNICHAR(10060)) Ces formules affichent respectivement \"Completed \u2714\", \"Pending \u23f3\", et \"Canceled \u274c\".<\/code><\/pre>\n<p>Cette m\u00e9thode facilite une identification rapide et claire du statut des commandes, optimisant la lisibilit\u00e9 des informations dans vos rapports.<\/p>\n<p>En conclusion, la fonction UNICHAR d&rsquo;Excel et UNICAR de Google Sheets enrichit vos possibilit\u00e9s de travail avec des symboles et caract\u00e8res sp\u00e9ciaux, ajoutant clart\u00e9, style et efficacit\u00e9 \u00e0 vos pr\u00e9sentations de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Renvoie le caract\u00e8re r\u00e9f\u00e9renc\u00e9 par la valeur num\u00e9rique donn\u00e9e<\/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-6825","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction UNICHAR (UNICAR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction UNICHAR (UNICAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/unichar\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction UNICHAR (UNICAR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction UNICHAR (UNICAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/unichar\/\" \/>\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:45+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction UNICHAR (UNICAR) 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\/unichar\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/unichar\/\",\"name\":\"Fonction UNICHAR (UNICAR) 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:45+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction UNICHAR (UNICAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/unichar\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/unichar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/unichar\/#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\":\"UNICAR\"}]},{\"@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 UNICHAR (UNICAR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction UNICHAR (UNICAR) 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\/unichar\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction UNICHAR (UNICAR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction UNICHAR (UNICAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/unichar\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:45+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction UNICHAR (UNICAR) 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\/unichar\/","url":"https:\/\/functiontranslator.com\/fr\/unichar\/","name":"Fonction UNICHAR (UNICAR) 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:45+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction UNICHAR (UNICAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/unichar\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/unichar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/unichar\/#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":"UNICAR"}]},{"@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\/6825","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=6825"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6825\/revisions"}],"predecessor-version":[{"id":29834,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6825\/revisions\/29834"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}