{"id":6447,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction\/"},"modified":"2021-02-26T08:03:23","modified_gmt":"2021-02-26T08:03:23","slug":"concat","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/concat\/","title":{"rendered":"CONCAT"},"content":{"rendered":"

La fonction CONCAT est commune \u00e0 Microsoft Excel et Google Sheets et permet de fusionner plusieurs cha\u00eenes de texte en une seule. Son utilisation est particuli\u00e8rement pr\u00e9cieuse dans diverses situations telles que le traitement de donn\u00e9es textuelles et l’\u00e9laboration de rapports.<\/p>\n

Description et syntaxe<\/h2>\n

Dans Excel, la fonction CONCAT a remplac\u00e9 CONCATENER, offrant ainsi une plus grande flexibilit\u00e9 pour concat\u00e9ner une s\u00e9rie de cellules sans l’utilisation d’un s\u00e9parateur sp\u00e9cifique. La syntaxe de base de CONCAT dans Excel est :<\/p>\n

=CONCAT(texte1, [texte2], ...)<\/code><\/pre>\n
O\u00f9 texte1, texte2, ...<\/code> d\u00e9signent les cha\u00eenes de caract\u00e8res \u00e0 assembler. Ces \u00e9l\u00e9ments peuvent \u00eatre des r\u00e9f\u00e9rences de cellules, des cha\u00eenes de caract\u00e8res explicites ou des r\u00e9sultats de formules.<\/p>\n
Google Sheets utilise \u00e9galement une syntaxe similaire pour sa fonction CONCAT, bien que dans certains cas, la fonction CONCATENATE soit pr\u00e9f\u00e9r\u00e9e pour assurer une compatibilit\u00e9 avec les versions ant\u00e9rieures.<\/p>\n
Exemples pratiques d’utilisation<\/h2>\n
Explorons des cas pratiques o\u00f9 la fonction CONCAT s’av\u00e8re particuli\u00e8rement utile :<\/p>\n
Cas pratique n\u00b01: Cr\u00e9ation d’une adresse email<\/h2>\n
Supposons que vous disposiez d’une liste de pr\u00e9noms et de noms dans une feuille de calcul et que vous souhaitiez g\u00e9n\u00e9rer des adresses email pour chaque individu.<\/p>\n
    \n
  • Pr\u00e9nom : A2 (exemple : Jean)<\/li>\n
  • Nom : B2 (exemple : Dupont)<\/li>\n<\/ul>\n
    La formule pour cr\u00e9er l’email sous la forme \u00ab\u00a0jean.dupont@email.com\u00a0\u00bb serait :<\/p>\n
    =CONCAT(LOWER(A2), \".\", LOWER(B2), \"@email.com\")<\/code><\/pre>\n
    Cette formule convertit le pr\u00e9nom et le nom en minuscules avec la fonction LOWER, puis les assemble avec un point et un domaine de messagerie explicite.<\/p>\n
    Cas pratique n\u00b02: Formatage d’une date<\/h2>\n
    Imaginons maintenant que vous avez les composantes d’une date dans diff\u00e9rentes cellules et que vous voulez les assembler en un format de date sp\u00e9cifique.<\/p>\n
      \n
    • Jour : A3 (exemple : 5)<\/li>\n
    • Mois : B3 (exemple : Mars)<\/li>\n
    • Ann\u00e9e : C3 (exemple : 2023)<\/li>\n<\/ul>\n
      Vous pouvez utiliser CONCAT pour formatter cette date de mani\u00e8re lisible :<\/p>\n
      =CONCAT(A3, \" \", B3, \" \", C3)<\/code><\/pre>\n
      Cette formule regroupe le jour, le mois et l’ann\u00e9e en s\u00e9parant chaque composante par un espace, r\u00e9sultant en la cha\u00eene de texte \u00ab\u00a05 Mars 2023\u00a0\u00bb.<\/p>\n
      Des fonctions telles que CONCAT sont essentielles pour manipuler et pr\u00e9parer les donn\u00e9es en vue de leur analyse, de la cr\u00e9ation de rapports ou simplement pour am\u00e9liorer la clart\u00e9 des informations dans vos documents Excel ou Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Combine le texte de plusieurs plages et\/ou cha\u00eenes, mais ne fournit pas le d\u00e9limiteur ou les arguments IgnoreEmpty<\/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-6447","post","type-post","status-publish","format-standard","hentry","category-texte"],"acf":[],"yoast_head":"\nFonction CONCAT dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CONCAT 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\/concat\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CONCAT dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CONCAT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/concat\/\" \/>\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:23+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CONCAT 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\/concat\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/concat\/\",\"name\":\"Fonction CONCAT 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:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CONCAT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/concat\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/concat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/concat\/#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\":\"CONCAT\"}]},{\"@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 CONCAT dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CONCAT 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\/concat\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CONCAT dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CONCAT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/concat\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CONCAT 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\/concat\/","url":"https:\/\/functiontranslator.com\/fr\/concat\/","name":"Fonction CONCAT 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:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CONCAT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/concat\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/concat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/concat\/#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":"CONCAT"}]},{"@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\/6447","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=6447"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6447\/revisions"}],"predecessor-version":[{"id":29459,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6447\/revisions\/29459"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}