{"id":6746,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/remplacer-remplacerb\/"},"modified":"2021-02-26T08:12:54","modified_gmt":"2021-02-26T08:12:54","slug":"replace-replacebs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/","title":{"rendered":"REMPLACER, REMPLACERB"},"content":{"rendered":"

Dans cet article, nous examinons les fonctions REPLACE<\/code> (REMPLACER) et REPLACEB<\/code> (REMPLACERB) de Microsoft Excel et Google Sheets, qui sont essentielles pour la manipulation de textes. Elles permettent de remplacer une section sp\u00e9cifique d’une cha\u00eene de caract\u00e8res par une autre.<\/p>\n

Syntaxe et Utilisation<\/h2>\n

Voici la syntaxe de la fonction REPLACE<\/code> :<\/p>\n

REPLACE(texte_original, position_debut, nombre_caracteres, texte_remplacement)<\/code><\/pre>\n
D\u00e9tails des param\u00e8tres :<\/p>\n
    \n
  • texte_original<\/strong> : la cha\u00eene de caract\u00e8res \u00e0 modifier.<\/li>\n
  • position_debut<\/strong> : la position du premier caract\u00e8re \u00e0 remplacer dans le texte_original<\/em>.<\/li>\n
  • nombre_caracteres<\/strong> : le nombre de caract\u00e8res \u00e0 remplacer dans le texte_original<\/em>.<\/li>\n
  • texte_remplacement<\/strong> : le texte de remplacement.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    =REPLACE(\"Bonjour Monde\", 8, 5, \"Ami\")<\/code><\/pre>\n
    Le r\u00e9sultat sera \u00ab\u00a0Bonjour Ami\u00a0\u00bb<\/em>, car \u00ab\u00a0Monde\u00a0\u00bb<\/em> a \u00e9t\u00e9 remplac\u00e9 par \u00ab\u00a0Ami\u00a0\u00bb<\/em>.<\/p>\n
    La fonction REPLACEB<\/code> est similaire \u00e0 REPLACE<\/code> mais op\u00e8re en comptant les bytes<\/strong> plut\u00f4t que les caract\u00e8res<\/strong>, ce qui est utile pour les langues utilisant des encodages multibytes.<\/p>\n
    Exemples pratiques<\/h2>\n\n\n\n\n
    Utilisation<\/th>\nDescription<\/th>\nFormule<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    Modification d’une date<\/td>\nTransformer le format d’une date de MMJJAAAA \u00e0 JJ\/MM\/AAAA<\/td>\n\n
    =REPLACE(\"01022023\", 3, 0, \"\/\")
    =REPLACE(reponse_prec, 6, 0, \"\/\")<\/code><\/pre>\n<\/td>\n
    		\u00ab\u00a001\/02\/2023\u00a0\u00bb<\/td>\n<\/tr>\n
    Correction de texte<\/td>\nCorriger une faute de frappe<\/td>\n\n
    =REPLACE(\"Chein\", 1, 1, \"Ch\")<\/code><\/pre>\n<\/td>\n
    		\u00ab\u00a0Chien\u00a0\u00bb<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios d’application concr\u00e8te<\/h2>\n
    Formatage de num\u00e9ros de t\u00e9l\u00e9phone<\/h2>\n
    Pour reformatter une cha\u00eene de dix chiffres repr\u00e9sentant un num\u00e9ro de t\u00e9l\u00e9phone, telle que \u00ab\u00a01234567890\u00a0\u00bb, en \u00ab\u00a0(123) 456-7890\u00a0\u00bb :<\/p>\n
    =REPLACE(REPLACE(\"1234567890\", 1, 0, \"(\"), 4, 0, \") \") =REPLACE(reponse_prec, 9, 0, \"-\")<\/code><\/pre>\n
    Le r\u00e9sultat obtenu sera (123) 456-7890<\/em>.<\/p>\n
    Modification de codes produits<\/h2>\n
    Pour mettre \u00e0 jour les codes produits de \u00ab\u00a0OLD123\u00a0\u00bb \u00e0 \u00ab\u00a0NEW123\u00a0\u00bb, utilisez REPLACE :<\/p>\n
    =REPLACE(\"OLD123\", 1, 3, \"NEW\")<\/code><\/pre>\n
    Ce faisant, \u00ab\u00a0OLD123\u00a0\u00bb est transform\u00e9 en \u00ab\u00a0NEW123\u00a0\u00bb.<\/p>\n
    Ces fonctions s’av\u00e8rent des outils pr\u00e9cieux pour tout ce qui touche \u00e0 la manipulation de texte dans les feuilles de calcul, offrant une grande flexibilit\u00e9 et pr\u00e9cision dans le formatage et la correction des donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Remplace des caRact\u00e8Res dans un 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-6746","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) 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\/replace-replacebs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/\" \/>\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:12:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) 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\/replace-replacebs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/\",\"name\":\"Fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) 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:12:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/#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\":\"REMPLACER, REMPLACERB\"}]},{\"@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 REPLACE, REPLACEBs (REMPLACER, REMPLACERB) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) 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\/replace-replacebs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) 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\/replace-replacebs\/","url":"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/","name":"Fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) 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:12:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction REPLACE, REPLACEBs (REMPLACER, REMPLACERB) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/replace-replacebs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/replace-replacebs\/#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":"REMPLACER, REMPLACERB"}]},{"@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\/6746","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=6746"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6746\/revisions"}],"predecessor-version":[{"id":29757,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6746\/revisions\/29757"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}