{"id":91,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/concat\/"},"modified":"2021-02-13T11:33:08","modified_gmt":"2021-02-13T11:33:08","slug":"concat","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/concat\/","title":{"rendered":"CONCAT"},"content":{"rendered":"

Today, we’re going to delve into a useful function available in both Ms Excel and Google Sheets named CONCAT. The CONCAT function is designed to merge multiple strings into one continuous text string. This is particularly valuable for amalgamating text from various cells or incorporating specific text into existing cell values.<\/p>\n

Basic Syntax<\/h2>\n

The standard formula structure for the CONCAT function is as follows:<\/p>\n

=CONCAT(text1, [text2], ...)<\/code><\/pre>\n
    \n
  • text1<\/code>: This is the initial string or cell reference you wish to concatenate.<\/li>\n
  • text2<\/code> (optional): These are additional strings or cell references you may include in the concatenation.<\/li>\n
  • The function can accept up to 253 text arguments with each argument allowing a maximum of 32,767 characters.<\/li>\n<\/ul>\n
    Examples<\/h2>\n
    Example 1: Basic Usage<\/h2>\n
    Consider two cells where cell A1 contains “Apple” and cell B1 contains “Banana”. To merge these two into one cell using CONCAT:<\/p>\n\n\n\n
    A<\/th>\nB<\/th>\nC<\/th>\n<\/tr>\n
    Apple<\/td>\nBanana<\/td>\n=CONCAT(A1, B1)<\/td>\n<\/tr>\n<\/table>\n
    The formula =CONCAT(A1, B1)<\/code> in cell C1 will produce “AppleBanana”.<\/p>\n
    Example 2: Adding Spaces<\/h2>\n
    To insert a space between “Apple” and “Banana”, modify the formula as follows:<\/p>\n\n\n\n
    A<\/th>\nB<\/th>\nC<\/th>\n<\/tr>\n
    Apple<\/td>\nBanana<\/td>\n=CONCAT(A1, ” “, B1)<\/td>\n<\/tr>\n<\/table>\n
    Now, the formula =CONCAT(A1, \" \", B1)<\/code> in cell C1 will yield “Apple Banana”.<\/p>\n
    Example 3: Combining Multiple Cells<\/h2>\n
    If you need to merge content from more than two cells, simply add additional arguments to the CONCAT function:<\/p>\n\n\n\n
    A<\/th>\nB<\/th>\nC<\/th>\nD<\/th>\nE<\/th>\n<\/tr>\n
    Hello<\/td>\nfrom<\/td>\nExcel<\/td>\nand<\/td>\nSheets<\/td>\n<\/tr>\n<\/table>\n
    To combine these cells into cell F1, utilize the following formula:<\/p>\n
    =CONCAT(A1, \" \", B1, \" \", C1, \" \", D1, \" \", E1)<\/code><\/pre>\n
    The resulting text in cell F1 will be “Hello from Excel and Sheets”.<\/p>\n
    The CONCAT function in Excel and Google Sheets proves to be a versatile tool for merging text from different cells or interspersing specific text between values. Remember, you can enhance the function’s utility by incorporating separators or constants as necessary.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Combines the text from multiple ranges and\/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[202],"tags":[],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-text"],"acf":[],"yoast_head":"\nExcel CONCAT Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel CONCAT function does. Clear syntax explanation and useful formula examples.\" \/>\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\/en\/concat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel CONCAT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel CONCAT function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/concat\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:33:08+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel CONCAT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/concat\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/concat\/\",\"name\":\"Excel CONCAT Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:33:08+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel CONCAT function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/concat\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/concat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/concat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Text\",\"item\":\"https:\/\/functiontranslator.com\/en\/text\/\"},{\"@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\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel CONCAT Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel CONCAT function does. Clear syntax explanation and useful formula examples.","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\/en\/concat\/","og_locale":"en_US","og_type":"article","og_title":"Excel CONCAT Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel CONCAT function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/concat\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:33:08+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel CONCAT Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/concat\/","url":"https:\/\/functiontranslator.com\/en\/concat\/","name":"Excel CONCAT Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:33:08+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel CONCAT function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/concat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/concat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/concat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Text","item":"https:\/\/functiontranslator.com\/en\/text\/"},{"@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":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":2982,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/91\/revisions\/2982"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}