{"id":6809,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-joindre-texte\/"},"modified":"2021-02-26T08:15:09","modified_gmt":"2021-02-26T08:15:09","slug":"textjoin","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/textjoin\/","title":{"rendered":"joindre. texte"},"content":{"rendered":"

Introduction<\/h2>\n

La fonction TEXTJOIN<\/strong>, ou joindre.texte<\/em> en fran\u00e7ais, est un outil essentiel dans Microsoft Excel et Google Sheets. Elle permet de combiner plusieurs cha\u00eenes de texte en une seule. L’utilisateur peut sp\u00e9cifier un d\u00e9limiteur personnalis\u00e9 et choisir de ne pas inclure les cellules vides. TEXTJOIN est id\u00e9ale pour regrouper des informations issues de diverses cellules de mani\u00e8re organis\u00e9e.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction TEXTJOIN est la suivante :<\/p>\n

=TEXTJOIN(d\u00e9limiteur, ignorer_vide, texte1, [texte2], ...)<\/code><\/pre>\n
    \n
  • d\u00e9limiteur<\/strong> : Le texte ou caract\u00e8re utilis\u00e9 pour s\u00e9parer les \u00e9l\u00e9ments combin\u00e9s.<\/li>\n
  • ignorer_vide<\/strong> : Valeur bool\u00e9enne (VRAI ou FAUX). Si VRAI, les cellules vides ne sont pas incluses dans le r\u00e9sultat final.<\/li>\n
  • texte1, [texte2],…<\/strong> : Les cha\u00eenes de texte \u00e0 concat\u00e9ner. Ces arguments peuvent \u00eatre des r\u00e9f\u00e9rences de cellules ou du texte brut.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Consid\u00e9rons que vous poss\u00e9dez plusieurs cellules contenant des d\u00e9tails sur un \u00e9v\u00e9nement :<\/p>\n\n\n\n\n\n
    Cellule<\/th>\nValeur<\/th>\n<\/tr>\n
    A1<\/td>\nNom de l’\u00e9v\u00e9nement<\/td>\n<\/tr>\n
    A2<\/td>\nDate<\/td>\n<\/tr>\n
    A3<\/td>\nLieu<\/td>\n<\/tr>\n<\/table>\n
    Vous pouvez les combiner en utilisant la fonction TEXTJOIN de la mani\u00e8re suivante :<\/p>\n
    =TEXTJOIN(\" - \", VRAI, A1, A2, A3)<\/code><\/pre>\n
    Cette formule concat\u00e8ne les valeurs de A1, A2, et A3, en les s\u00e9parant par \u00a0\u00bb – \u00ab\u00a0, et en excluant les \u00e9ventuelles cellules vides.<\/p>\n
    Cas pratiques<\/h2>\n
    Regrouper des donn\u00e9es pour un rapport<\/h3>\n
    Imaginons que vous devez pr\u00e9parer un rapport listant le pr\u00e9nom, le nom, et le d\u00e9partement de divers individus, chaque \u00e9l\u00e9ment \u00e9tant s\u00e9par\u00e9 par un symbole de pipe (|). Voici les donn\u00e9es :<\/p>\n\n\n\n\n
    Pr\u00e9nom<\/th>\nNom<\/th>\nD\u00e9partement<\/th>\n<\/tr>\n
    Jean<\/td>\nDupont<\/td>\nComptabilit\u00e9<\/td>\n<\/tr>\n
    Marie<\/td>\nCurie<\/td>\nRecherche<\/td>\n<\/tr>\n<\/table>\n
    =TEXTJOIN(\"|\", FAUX, A1, B1, C1)<\/code><\/pre>\n
    Cette formule produit \u00ab\u00a0Jean|Dupont|Comptabilit\u00e9\u00a0\u00bb.<\/p>\n
    Cr\u00e9ation d’une liste d’emails<\/h3>\n
    Si vous avez une liste d’adresses email dans une colonne et souhaitez cr\u00e9er une seule cha\u00eene les contenant toutes, s\u00e9par\u00e9es par des points-virgules pour un envoi group\u00e9, voici comment proc\u00e9der :<\/p>\n
    =TEXTJOIN(\";\", VRAI, A1:A100)<\/code><\/pre>\n
    A1:A100 repr\u00e9sente la plage contenant les adresses email. Cette fonction concat\u00e8ne toutes les adresses de cette plage, en ignorant les cellules vides.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Combine le texte \u00e0 partir de plusieurs plages et\/ou cha\u00eenes, et inclut un s\u00e9parateur que vous sp\u00e9cifiez entre chaque valeur de texte \u00e0 combiner Si le d\u00e9limiteur est une cha\u00eene de texte vide, cette fonction concat\u00e8ne effectivement les plages<\/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-6809","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction TEXTJOIN (joindre. texte) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TEXTJOIN (joindre. texte) 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\/textjoin\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TEXTJOIN (joindre. texte) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TEXTJOIN (joindre. texte) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/textjoin\/\" \/>\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:09+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TEXTJOIN (joindre. texte) 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\/textjoin\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/textjoin\/\",\"name\":\"Fonction TEXTJOIN (joindre. texte) 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:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TEXTJOIN (joindre. texte) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/textjoin\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/textjoin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/textjoin\/#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\":\"joindre. texte\"}]},{\"@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 TEXTJOIN (joindre. texte) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TEXTJOIN (joindre. texte) 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\/textjoin\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TEXTJOIN (joindre. texte) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TEXTJOIN (joindre. texte) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/textjoin\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TEXTJOIN (joindre. texte) 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\/textjoin\/","url":"https:\/\/functiontranslator.com\/fr\/textjoin\/","name":"Fonction TEXTJOIN (joindre. texte) 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:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TEXTJOIN (joindre. texte) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/textjoin\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/textjoin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/textjoin\/#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":"joindre. texte"}]},{"@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\/6809","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=6809"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6809\/revisions"}],"predecessor-version":[{"id":29818,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6809\/revisions\/29818"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}