{"id":6786,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/substitue\/"},"modified":"2021-02-26T08:14:18","modified_gmt":"2021-02-26T08:14:18","slug":"substitute","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/substitute\/","title":{"rendered":"SUBSTITUE"},"content":{"rendered":"

La fonction SUBSTITUTE (SUBSTITUE en fran\u00e7ais) dans Microsoft Excel et Google Sheets permet de remplacer une partie sp\u00e9cifique du texte par un autre texte au sein d’une cha\u00eene. Elle est particuli\u00e8rement efficace pour effectuer des modifications cibl\u00e9es sur des cha\u00eenes de texte, telles que la mise \u00e0 jour de dates, la modification d’abr\u00e9viations ou l’ajustement de noms dans une liste. Contrairement \u00e0 la fonction REPLACE, qui remplace du texte \u00e0 des emplacements sp\u00e9cifiques, SUBSTITUTE cherche et remplace des cha\u00eenes de texte d\u00e9finies.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici comment se pr\u00e9sente la syntaxe de la fonction SUBSTITUTE :<\/p>\n

SUBSTITUTE(texte, ancien_texte, nouveau_texte, [n_occurrence])<\/strong><\/code><\/pre>\n
    \n
  • texte<\/strong> : le texte initial ou la r\u00e9f\u00e9rence \u00e0 la cellule qui contient le texte \u00e0 modifier.<\/li>\n
  • ancien_texte<\/strong> : le segment de texte que vous souhaitez remplacer.<\/li>\n
  • nouveau_texte<\/strong> : le texte qui remplacera l’ancien texte.<\/li>\n
  • n_occurrence<\/strong> (optionnel) : sp\u00e9cifie l’occurrence pr\u00e9cise de l’ancien texte \u00e0 remplacer. Si ce param\u00e8tre n’est pas sp\u00e9cifi\u00e9, toutes les occurrences de l’ancien_texte seront remplac\u00e9es.<\/li>\n<\/ul>\n
    Exemple simple :<\/p>\n
    =SUBSTITUTE(\"Bonjour monde\", \"monde\", \"tous\")<\/code><\/pre>\n
    Ceci retournera : \u00ab\u00a0Bonjour tous\u00a0\u00bb.<\/p>\n
    Applications pratiques<\/h2>\n
    Correction automatique de textes<\/h2>\n
    Pour corriger automatiquement des erreurs de frappe r\u00e9currentes dans une liste de textes, vous pourriez, par exemple, vouloir changer \u00ab\u00a0Execl\u00a0\u00bb en \u00ab\u00a0Excel\u00a0\u00bb.<\/p>\n
    =SUBSTITUTE(A1, \"Execl\", \"Excel\")<\/code><\/p><\/pre>\n
    Copiez cette formule le long de la colonne pour corriger toutes les occurrences de la faute typographique.<\/p>\n
    Normalisation des formats de date<\/h2>\n
    Si vous recevez des donn\u00e9es avec des dates au format \u00ab\u00a0JJ.MMM.AAAA\u00a0\u00bb et souhaitez les convertir en \u00ab\u00a0JJ\/MM\/AAAA\u00a0\u00bb, la fonction SUBSTITUTE vous permettra de remplacer les points par des barres obliques.<\/p>\n
    =SUBSTITUTE(A1, \".\", \"\/\")<\/code><\/p><\/pre>\n
    Cette simple substitution normalisera le format de vos dates sur l’ensemble de vos donn\u00e9es.<\/p>\n
    En conclusion, la fonction SUBSTITUTE est un outil indispensable pour la manipulation, la correction et le nettoyage de cha\u00eenes de caract\u00e8res dans vos tableaux. Elle facilite la correction d’erreurs courantes et la r\u00e9formatation de textes de mani\u00e8re efficace et pr\u00e9cise.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Remplace l\u2019ancien texte d\u2019une cha\u00eene de caRact\u00e8Res paR un nouveau<\/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-6786","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction SUBSTITUTE (SUBSTITUE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SUBSTITUTE (SUBSTITUE) 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\/substitute\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SUBSTITUTE (SUBSTITUE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SUBSTITUTE (SUBSTITUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/substitute\/\" \/>\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:14:18+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SUBSTITUTE (SUBSTITUE) 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\/substitute\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/substitute\/\",\"name\":\"Fonction SUBSTITUTE (SUBSTITUE) 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:14:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SUBSTITUTE (SUBSTITUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/substitute\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/substitute\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/substitute\/#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\":\"SUBSTITUE\"}]},{\"@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 SUBSTITUTE (SUBSTITUE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SUBSTITUTE (SUBSTITUE) 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\/substitute\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SUBSTITUTE (SUBSTITUE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SUBSTITUTE (SUBSTITUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/substitute\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SUBSTITUTE (SUBSTITUE) 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\/substitute\/","url":"https:\/\/functiontranslator.com\/fr\/substitute\/","name":"Fonction SUBSTITUTE (SUBSTITUE) 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:14:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SUBSTITUTE (SUBSTITUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/substitute\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/substitute\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/substitute\/#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":"SUBSTITUE"}]},{"@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\/6786","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=6786"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6786\/revisions"}],"predecessor-version":[{"id":29795,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6786\/revisions\/29795"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}