{"id":6392,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/asc\/"},"modified":"2021-02-26T08:01:53","modified_gmt":"2021-02-26T08:01:53","slug":"asc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/asc\/","title":{"rendered":"ASC"},"content":{"rendered":"<h2>Syntaxe et description de la fonction<\/h2>\n<p>La fonction <code>ASC<\/code> dans Microsoft Excel permet de convertir les caract\u00e8res du jeu de caract\u00e8res \u00e0 double octet (DBCS, pour Double Byte Character Set) en caract\u00e8res du jeu de caract\u00e8res \u00e0 octet unique (SBCS, pour Single Byte Character Set). Cette fonction est essentiellement utilis\u00e9e pour g\u00e9rer les caract\u00e8res des langues asiatiques telles que le japonais ou le chinois. Il est important de noter que cette fonction n&rsquo;est pas disponible dans Google Sheets.<\/p>\n<p>Syntaxe de la fonction dans Excel :<\/p>\n<pre><code>ASC(texte)<\/code><\/pre>\n<p>O\u00f9 <code>texte<\/code> est la cha\u00eene de caract\u00e8res \u00e0 convertir.<\/p>\n<p>Exemple :<\/p>\n<pre><code>=ASC(\"\uff21\uff22\uff23\")<\/code><\/pre>\n<p>Cet exemple transforme les caract\u00e8res japonais full-width en caract\u00e8res half-width.<\/p>\n<h2>Applications pratiques de la fonction<\/h2>\n<p>Voici quelques sc\u00e9narios o\u00f9 l&rsquo;utilisation de la fonction <code>ASC<\/code> peut \u00eatre particuli\u00e8rement utile :<\/p>\n<h2>1. Normalisation des donn\u00e9es pour les bases de donn\u00e9es<\/h2>\n<p>Lorsque des donn\u00e9es en langues asiatiques sont saisies \u00e0 travers diff\u00e9rents syst\u00e8mes qui n&#8217;emploient pas le m\u00eame encodage, convertir des caract\u00e8res full-width en half-width peut faciliter l&rsquo;unification et la comparaison des donn\u00e9es.<\/p>\n<p>Exemple :<\/p>\n<pre><code>=ASC(\"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\")<\/code><\/pre>\n<p>Imaginez que \u00ab\u00a0\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u00a0\u00bb soit saisi en full-width et que votre base de donn\u00e9es exige des caract\u00e8res en half-width pour les requ\u00eates. En utilisant <code>ASC<\/code>, vous convertissez ces entr\u00e9es pour assurer la coh\u00e9rence des donn\u00e9es dans votre base de donn\u00e9es.<\/p>\n<h2>2. Am\u00e9lioration de l&rsquo;affichage des donn\u00e9es<\/h2>\n<p>La conversion de caract\u00e8res full-width en half-width peut souvent am\u00e9liorer la lisibilit\u00e9 des textes dans les rapports ou les interfaces utilisateur qui ne g\u00e8rent pas bien les caract\u00e8res full-width.<\/p>\n<p>Exemple :<\/p>\n<pre><code>=ASC(\"\u30d5\u30eb\u30ef\u30a4\u30c9\")<\/code><\/pre>\n<p>Cette transformation r\u00e9duit la largeur des caract\u00e8res, rendant le texte plus compact et potentiellement plus lisible, selon le contexte de l&rsquo;interface utilisateur.<\/p>\n<h2>Tableau de comparaison<\/h2>\n<table>\n<tr>\n<th>Avant<\/th>\n<th>Apr\u00e8s<\/th>\n<\/tr>\n<tr>\n<td>\uff21\uff22\uff23<\/td>\n<td>ABC<\/td>\n<\/tr>\n<tr>\n<td>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/td>\n<td>\uff83\uff9e\uff70\uff80\uff8d\uff9e\uff70\uff7d<\/td>\n<\/tr>\n<tr>\n<td>\u30d5\u30eb\u30ef\u30a4\u30c9<\/td>\n<td>\uff8c\uff99\uff9c\uff72\uff84\uff9e<\/td>\n<\/tr>\n<\/table>\n<p>Ce tableau montre clairement comment les textes sont convertis de full-width \u00e0 half-width, facilitant ainsi leur gestion et leur affichage dans divers contextes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Change les CaraCt\u00e8res anglais ou katakana \u00e0 pleine Chasse (Cod\u00e9s sur deux oCtets) \u00e0 l\u2019int\u00e9rieur d\u2019une Cha\u00eene de CaraCt\u00e8res en CaraCt\u00e8res \u00e0 demi-Chasse (Cod\u00e9s sur un oCtet)<\/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-6392","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 ASC dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ASC 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\/asc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ASC dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ASC 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\/asc\/\" \/>\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:01:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ASC 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\/asc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/asc\/\",\"name\":\"Fonction ASC 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:01:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ASC d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/asc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/asc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/asc\/#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\":\"ASC\"}]},{\"@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 ASC dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ASC 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\/asc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ASC dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ASC d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/asc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:01:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ASC 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\/asc\/","url":"https:\/\/functiontranslator.com\/fr\/asc\/","name":"Fonction ASC 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:01:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ASC d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/asc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/asc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/asc\/#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":"ASC"}]},{"@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\/6392","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=6392"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6392\/revisions"}],"predecessor-version":[{"id":29404,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6392\/revisions\/29404"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}