{"id":6448,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/concatener\/"},"modified":"2021-02-26T08:03:25","modified_gmt":"2021-02-26T08:03:25","slug":"concatenate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/concatenate\/","title":{"rendered":"CONCATENER"},"content":{"rendered":"

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

La fonction CONCATENER, pr\u00e9sente dans Microsoft Excel et Google Sheets, permet de combiner deux ou plusieurs cha\u00eenes de texte en une seule. Elle est particuli\u00e8rement utile pour le traitement des donn\u00e9es textuelles.<\/p>\n

Syntaxe dans Microsoft Excel :<\/b><\/p>\n

CONCATENATE(texte1, [texte2], ...)<\/code><\/pre>\n
Syntaxe dans Google Sheets :<\/b><\/p>\n
CONCATENER(texte1, [texte2], ...)<\/code><\/pre>\n
Dans ces fonctions, texte1<\/code>, texte2<\/code>, …, d\u00e9signent les cha\u00eenes de caract\u00e8res ou les r\u00e9f\u00e9rences de cellules contenant les textes \u00e0 concat\u00e9ner.<\/p>\n
Exemple :<\/b><\/p>\n
    \n
  • Dans Excel ou Google Sheets, supposons que la cellule A1<\/code> contienne \u00ab\u00a0Bonjour\u00a0\u00bb et la cellule B1<\/code> \u00ab\u00a0Monde\u00a0\u00bb. La formule :<\/li>\n
    =CONCATENER(A1, \" \", B1)<\/code><\/pre>\n
  • retournera \u00ab\u00a0Bonjour Monde\u00a0\u00bb.<\/li>\n<\/ul>\n
    Applications pratiques<\/h2>\n
    Cette fonction s’av\u00e8re tr\u00e8s utile dans une vari\u00e9t\u00e9 de contextes pour simplifier la manipulation et la pr\u00e9sentation des donn\u00e9es textuelles.<\/p>\n
    Exemple 1 : Cr\u00e9ation d’une adresse email<\/h2>\n
    Imaginez que vous disposiez d’une liste de pr\u00e9noms en colonne A et de noms en colonne B, et que vous souhaitez g\u00e9n\u00e9rer des adresses email pour chacun.<\/p>\n
    A B Jean Dupont Marie Curie<\/code><\/pre>\n
    Avec la fonction CONCATENER, il est simple de cr\u00e9er des adresses email en ajoutant \u00ab\u00a0@entreprise.com\u00a0\u00bb \u00e0 la fin de chaque nom complet.<\/p>\n
    En C1 : =CONCATENER(A1, \".\", B1, \"@entreprise.com\") Ce qui retournera \"Jean.Dupont@entreprise.com\" pour cette cellule et ainsi de suite pour les autres lignes.<\/code><\/pre>\n
    Exemple 2 : Assemblage de donn\u00e9es pour affichage<\/h2>\n
    CONCATENER peut \u00e9galement assembler des informations provenant de diff\u00e9rentes cellules pour une pr\u00e9sentation plus claire et structur\u00e9e. Par exemple, si vous avez des informations de date, heure et \u00e9v\u00e9nement s\u00e9par\u00e9es dans un tableau :<\/p>\n
    A B C 12\/12 08:00 R\u00e9union<\/code><\/pre>\n
    Vous pouvez concat\u00e9ner ces \u00e9l\u00e9ments en une seule cellule pour am\u00e9liorer la lisibilit\u00e9 :<\/p>\n
    En D1 : =CONCATENER(\"Le \", A1, \" \u00e0 \", B1, \", \", C1) Cela donnera \"Le 12\/12 \u00e0 08:00, R\u00e9union\".<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
    Assemble plusieurs \u00e9l\u00e9ments textuels de fA\u00e7on \u00e0 n\u2019en former qu\u2019un seul<\/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-6448","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction CONCATENATE (CONCATENER) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CONCATENATE (CONCATENER) 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\/concatenate\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CONCATENATE (CONCATENER) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CONCATENATE (CONCATENER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/concatenate\/\" \/>\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:03:25+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CONCATENATE (CONCATENER) 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\/concatenate\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/concatenate\/\",\"name\":\"Fonction CONCATENATE (CONCATENER) 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:03:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CONCATENATE (CONCATENER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/concatenate\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/concatenate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/concatenate\/#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\":\"CONCATENER\"}]},{\"@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 CONCATENATE (CONCATENER) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CONCATENATE (CONCATENER) 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\/concatenate\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CONCATENATE (CONCATENER) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CONCATENATE (CONCATENER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/concatenate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CONCATENATE (CONCATENER) 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\/concatenate\/","url":"https:\/\/functiontranslator.com\/fr\/concatenate\/","name":"Fonction CONCATENATE (CONCATENER) 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:03:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CONCATENATE (CONCATENER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/concatenate\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/concatenate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/concatenate\/#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":"CONCATENER"}]},{"@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\/6448","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=6448"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6448\/revisions"}],"predecessor-version":[{"id":29460,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6448\/revisions\/29460"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}