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

La fonction DBCS est principalement utilis\u00e9e dans des applications de traitement de donn\u00e9es telles que Microsoft Excel pour convertir un caract\u00e8re \u00e0 demi-largeur (single byte character) en un caract\u00e8re \u00e0 pleine largeur (double byte character). Cette fonction est particuli\u00e8rement utile pour les langues telles que le japonais ou le chinois, dans lesquelles les caract\u00e8res peuvent varier en largeur.<\/p>\n

Syntaxe et exemples d’utilisation<\/h2>\n

Dans Excel, la fonction DBCS s’utilise comme suit :<\/p>\n

=DBCS(texte)<\/code><\/pre>\n
O\u00f9 texte<\/code> est le texte que vous souhaitez convertir. Voici un exemple concret :<\/p>\n
    \n
  • Si vous avez le caract\u00e8re \u00e0 demi-largeur \u00ab\u00a0A\u00a0\u00bb dans la cellule A1, la formule suivante :<\/li>\n<\/ul>\n
    =DBCS(A1)<\/code><\/pre>\n
    convertira \u00ab\u00a0A\u00a0\u00bb en son \u00e9quivalent \u00e0 pleine largeur, si une repr\u00e9sentation \u00e0 pleine largeur de ce caract\u00e8re existe.<\/p>\n
    \u00c0 noter que Google Sheets ne prend pas en charge directement la fonction DBCS. Des scripts ou des extensions sp\u00e9cifiques peuvent \u00eatre n\u00e9cessaires pour les utilisateurs de Google Sheets afin de reproduire cette fonctionnalit\u00e9.<\/p>\n
    Applications pratiques de la fonction<\/h2>\n
    Exemple 1 : Mise en forme de textes pour l’impression<\/h2>\n
    Imaginons que vous pr\u00e9parez un document pour l’impression et que l’esth\u00e9tique requise implique l’utilisation de caract\u00e8res \u00e0 pleine largeur pour certains segments du texte afin d’obtenir un effet visuel marquant :<\/p>\n
      \n
    • Vous disposez de noms de produits en caract\u00e8res \u00e0 demi-largeur dans la colonne A :<\/li>\n<\/ul>\n
      A2: TV A3: R\u00e9frig\u00e9rateur A4: Micro-onde<\/code><\/pre>\n
      En utilisant la fonction DBCS, vous pouvez convertir ces textes :<\/p>\n
      B2: =DBCS(A2) B3: =DBCS(A3) B4: =DBCS(A4)<\/code><\/pre>\n
      Cela transformera les noms de produits en caract\u00e8res \u00e0 pleine largeur, id\u00e9aux pour les titres ou les en-t\u00eates dans votre document d’impression.<\/p>\n
      Exemple 2 : Normalisation de donn\u00e9es dans une base de donn\u00e9es multilingue<\/h2>\n
      Dans une base de donn\u00e9es comprenant des noms d’utilisateurs dans diff\u00e9rentes langues, normaliser les caract\u00e8res afin qu’ils soient tous de la m\u00eame largeur peut simplifier l’affichage et le traitement des donn\u00e9es :<\/p>\n
        \n
      • Supposons que la colonne A contient divers noms d’utilisateurs avec des caract\u00e8res de largeurs vari\u00e9es.<\/li>\n<\/ul>\n
        A2: \u674e\u5c0f\u9f8d A3: Bruce Lee A4: \u739b\u4e3d\u4e9a<\/code><\/pre>\n
        En appliquant la fonction DBCS :<\/p>\n
        B2: =DBCS(A2) B3: =DBCS(A3) B4: =DBCS(A4)<\/code><\/pre>\n
        Cette op\u00e9ration uniformise la pr\u00e9sentation des noms dans toutes les interfaces utilisateur ou les rapports imprim\u00e9s, am\u00e9liorant la lisibilit\u00e9 et la coh\u00e9rence des donn\u00e9es.<\/p>\n
        En conclusion, bien que son utilisation soit sp\u00e9cifique et plut\u00f4t technique, la fonction DBCS dans Excel est un outil puissant pour g\u00e9rer les caract\u00e8res dans des langues n\u00e9cessitant des largeurs variables, facilitant ainsi la gestion des documents multilingues.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Change les CaraCt\u00e8res anglais ou katakana \u00e0 demi-Chasse (Cod\u00e9s sur un oCtet) \u00e0 l\u2019int\u00e9rieur d\u2019une Cha\u00eene de CaraCt\u00e8res en CaraCt\u00e8res \u00e0 pleine Chasse (Cod\u00e9s sur deux oCtets)<\/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-6492","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction DBCS dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DBCS 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\/dbcs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DBCS dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DBCS d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dbcs\/\" \/>\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:04:31+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DBCS 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\/dbcs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dbcs\/\",\"name\":\"Fonction DBCS 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:04:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DBCS d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dbcs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dbcs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dbcs\/#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\":\"DBCS\"}]},{\"@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 DBCS dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DBCS 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\/dbcs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DBCS dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DBCS d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dbcs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DBCS 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\/dbcs\/","url":"https:\/\/functiontranslator.com\/fr\/dbcs\/","name":"Fonction DBCS 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:04:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DBCS d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dbcs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dbcs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dbcs\/#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":"DBCS"}]},{"@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\/6492","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=6492"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6492\/revisions"}],"predecessor-version":[{"id":29504,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6492\/revisions\/29504"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}