{"id":1103,"date":"2018-07-01T11:07:13","date_gmt":"2018-07-01T11:07:13","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1103"},"modified":"2023-11-02T19:25:00","modified_gmt":"2023-11-02T19:25:00","slug":"concatenate","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/","title":{"rendered":"CONCATENATE function"},"content":{"rendered":"\n

Excel CONCATENATE Function allows you to combine or concatenate multiple text strings into a single string. It’s like putting together pieces of a puzzle to create a complete picture.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

CONCATENATE(text1, [text2], …)<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
text1<\/strong><\/td>The first text or string you want to combine.<\/td><\/tr>
[text2]<\/strong><\/td>(Optional) Additional text or strings you want to join. You can add more text by including text2, text3, and so on.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to use<\/h2>\n\n\n\n

Let’s say you have two cells in Excel, A1 containing “Hello,” and B1 containing ” world!” To combine these two strings into one cell, you can use the CONCATENATE function in cell C1. Here’s how you do it:<\/p>\n\n\n\n

=CONCATENATE(A1, B1)<\/code><\/pre>\n\n\n\n
This will result in the content of cell C1 as “Hello, world!”<\/p>\n\n\n\n
You can also concatenate more than two strings. For example, if you have text in cells A2, B2, and C2, you can combine them using:<\/p>\n\n\n\n
=CONCATENATE(A2, B2, C2)<\/code><\/pre>\n\n\n\n
Excel will merge the contents of these cells into a single string.<\/p>\n\n\n\n
Examples<\/h2>\n\n\n\n
Let’s explore some more examples to understand how CONCATENATE works:<\/p>\n\n\n\n
=CONCATENATE(\"I\", \" love\", \" Excel\")<\/code><\/pre>\n\n\n\n
This formula will result in “I love Excel.”<\/p>\n\n\n\n
=CONCATENATE(A1, \", it's a\", B1)<\/code><\/pre>\n\n\n\n
If A1 contains “Hello,” and B1 contains ” beautiful day!”, this formula will give you “Hello, it’s a beautiful day!”<\/p>\n\n\n\n
Remember, you can use this function to combine text from different cells, add spaces, punctuation, or any other characters you like.<\/p>\n\n\n\n
Additional information<\/h2>\n\n\n\n
The CONCATENATE function is a useful tool when you need to create custom labels, sentences, or any text combinations in your Excel worksheets. It simplifies the task of merging text and is commonly used in various Excel projects. If you encounter any unfamiliar terms or need more details about Excel functions, you can refer to the Microsoft Excel support page<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel CONCATENATE Function allows you to combine or concatenate multiple text strings into a single string. It’s like putting together pieces of a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nCONCATENATE function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CONCATENATE function\" \/>\n<meta property=\"og:description\" content=\"Excel CONCATENATE Function allows you to combine or concatenate multiple text strings into a single string. It’s like putting together pieces of a...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-01T11:07:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T19:25:00+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"CONCATENATE function\",\"datePublished\":\"2018-07-01T11:07:13+00:00\",\"dateModified\":\"2023-11-02T19:25:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/\"},\"wordCount\":283,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/\",\"name\":\"CONCATENATE function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-01T11:07:13+00:00\",\"dateModified\":\"2023-11-02T19:25:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/concatenate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CONCATENATE function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CONCATENATE function","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:\/\/officetuts.net\/excel\/functions\/concatenate\/","og_locale":"en_US","og_type":"article","og_title":"CONCATENATE function","og_description":"Excel CONCATENATE Function allows you to combine or concatenate multiple text strings into a single string. It’s like putting together pieces of a...","og_url":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/","article_published_time":"2018-07-01T11:07:13+00:00","article_modified_time":"2023-11-02T19:25:00+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"CONCATENATE function","datePublished":"2018-07-01T11:07:13+00:00","dateModified":"2023-11-02T19:25:00+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/"},"wordCount":283,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/","url":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/","name":"CONCATENATE function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-01T11:07:13+00:00","dateModified":"2023-11-02T19:25:00+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/concatenate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/concatenate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"CONCATENATE function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1103"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1103"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1103\/revisions"}],"predecessor-version":[{"id":16365,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1103\/revisions\/16365"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}