{"id":1116,"date":"2020-07-11T08:38:41","date_gmt":"2020-07-11T06:38:41","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1116"},"modified":"2024-05-28T22:19:30","modified_gmt":"2024-05-28T20:19:30","slug":"concatenate-with-a-line-break-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/","title":{"rendered":"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/3-Quick-Easy-ways-to-Concatenate-Excel-With-A-Line-Break.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-33504\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/3-Quick-Easy-ways-to-Concatenate-Excel-With-A-Line-Break-1024x576.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/3-Quick-Easy-ways-to-Concatenate-Excel-With-A-Line-Break-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/3-Quick-Easy-ways-to-Concatenate-Excel-With-A-Line-Break-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/3-Quick-Easy-ways-to-Concatenate-Excel-With-A-Line-Break-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/3-Quick-Easy-ways-to-Concatenate-Excel-With-A-Line-Break.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" title=\"\"><\/a><\/p>\n<p>Ever faced a situation when you are combining text from multiple cells with line break as separator?<\/p>\n<p>Looking for a new fix or hack for this? Keep reading!<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/#CONCATENATE_Excel_Function\" title=\"CONCATENATE Excel Function\">CONCATENATE Excel Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/#Line_Break_in_Excel\" title=\"Line Break in Excel\">Line Break in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/#3_ways_to_Excel_Concatenate_with_Line_Break\" title=\"3 ways to Excel Concatenate with Line Break\">3 ways to Excel Concatenate with Line Break<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/#METHOD_1_Use_Concatenate_Excel_Formula\" title=\"METHOD 1: Use Concatenate Excel Formula\">METHOD 1: Use Concatenate Excel Formula<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/#METHOD_2_Use_Ampersand_Sign\" title=\"METHOD 2: Use &amp; (Ampersand)\u00a0Sign\">METHOD 2: Use &amp; (Ampersand)\u00a0Sign<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/#METHOD_3_Use_TEXTJOIN_formula\" title=\"METHOD 3: Use TEXTJOIN formula\">METHOD 3: Use TEXTJOIN formula<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"CONCATENATE_Excel_Function\"><\/span><a id=\"concatenate-excel-function\"><\/a>CONCATENATE Excel Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do? <\/strong><\/em><\/p>\n<p>Joins two or more text strings into one string. The item can be a text value, number, or <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/jump-to-a-cell-reference-within-an-excel-formula\/\" target=\"_blank\" rel=\"noopener\">cell reference<\/a>.<\/p>\n<p><em><strong>Formula breakdown: <\/strong><\/em><\/p>\n<p>=CONCATENATE(<span style=\"color: #0000ff\">text1<\/span>, <span style=\"color: #ff6600\">[text2]<\/span>, <span style=\"color: #339966\">[text3], &#8230;<\/span>)<\/p>\n<p><em><strong>What it means: <\/strong><\/em><\/p>\n<p>=CONCATENATE(<span style=\"color: #0000ff\">the first text<\/span>, <span style=\"color: #ff6600\">the second text<\/span>, <span style=\"color: #339966\">and so on&#8230;<\/span>)<\/p>\n<hr \/>\n<p>CONCATENATE Excel function <strong>joins two or more text strings into one string<\/strong>.\u00a0 The item can be a text value, number, or cell reference.<\/p>\n<p>If you add a double quotation with a space in between &#8221; &#8221; then this will add a space between the texts selected on either side.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Line_Break_in_Excel\"><\/span><a id=\"line-break-in-excel\"><\/a>Line Break in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-line-breaks\/\" target=\"_blank\" rel=\"noopener\">Line Break in Excel<\/a> is added to end the current line and start a new line within the same cell. A long text with a line break and without a line break is shown below.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-2020-07-09-at-6.05.16-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18497\" title=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-2020-07-09-at-6.05.16-PM.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"535\" height=\"234\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-2020-07-09-at-6.05.16-PM.png 535w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-2020-07-09-at-6.05.16-PM-300x131.png 300w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><\/p>\n<p>In general, when you are typing a text in Excel and you need <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-line-breaks-in-excel\/\" target=\"_blank\" rel=\"noopener\">to add a line break<\/a>, you can <strong>simply press Alt + Enter<\/strong> and Excel will take you to the new line within the same cell.<\/p>\n<p>But what if you want that line break when you are trying to <strong>combine texts from different cells using a formula<\/strong>.<\/p>\n<p>This is exactly what we will <strong>cover in the next section<\/strong>!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_ways_to_Excel_Concatenate_with_Line_Break\"><\/span><a id=\"3-ways-to-excel-concatenate-with-line-break\"><\/a>3 ways to Excel Concatenate with Line Break<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Want to <strong>add a line break<\/strong> in between each text string?<\/p>\n<p>This is done by entering the <strong>CHAR( )<\/strong> function in between each text string\/argument.<\/p>\n<p>CHAR function returns a<strong> character specified by a number<\/strong> from 1 to 255. For example, CHAR(10) returns a line break in windows, CHAR(34) returns a &#8221; (double quote), CHAR(64) returns @, etc.<\/p>\n<p>So, by simply adding <strong>CHAR(10)<\/strong> in between your formula you can enter a line break. You will need to select<strong> WRAP TEXT<\/strong> in order to see each text on a separate line.<\/p>\n<div class=\"after-post-box\">\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>Follow the <strong>step-by-step tutorial<\/strong> below <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-3-5-ft-to-inches\/\" target=\"_blank\" rel=\"noopener\">to see how easy<\/a> it is to add a line break in Concatenate Excel using employee data on the example below. Don&#8217;t forget to <strong>download the Excel workbook<\/strong> and follow along:<\/p>\n<p class=\"line-two\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Concatenate.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">\u00a0download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Concatenate.xlsx<\/span><\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"METHOD_1_Use_Concatenate_Excel_Formula\"><\/span><span style=\"color: #ff0000\"><strong>METHOD 1: <\/strong><\/span>Use <strong>Concatenate<\/strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/\" target=\"_blank\" rel=\"noopener\">Excel Formula<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:\u00a0<\/strong><\/span>We need to enter the <strong>CONCATENATE<\/strong> Excel function in a blank cell:<\/p>\n<h3 style=\"text-align: center\"><span style=\"color: #0000ff\">=CONCATENATE(<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9723\" title=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate1.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"1049\" height=\"298\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate1.png 1049w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate1-300x85.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate1-1024x291.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate1-768x218.png 768w\" sizes=\"(max-width: 1049px) 100vw, 1049px\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> The <strong>CONCATENATE<\/strong> arguments:<\/p>\n<h3><span style=\"color: #0000ff\"><em><strong>text1, [text2], [text3], &#8230;<\/strong><\/em><\/span><\/h3>\n<p><strong>Which text do you want to join together?<\/strong><\/p>\n<p><em>Let us select all the columns:<\/em><\/p>\n<h3 style=\"text-align: center\">=CONCATENATE(<span style=\"color: #0000ff\">A12, B12, C12, D12)<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9717\" title=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate2.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"1036\" height=\"287\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate2.png 1036w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate2-300x83.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate2-1024x284.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate2-768x213.png 768w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><em>Now let&#8217;s add the function <strong>CHAR(10)<\/strong> to add a line break between each text<\/em><\/p>\n<h3 style=\"text-align: center\">=CONCATENATE(A12, <span style=\"color: #0000ff\">CHAR(10),<\/span> B12, <span style=\"color: #0000ff\">CHAR(10),<\/span> C12, <span style=\"color: #0000ff\">CHAR(10),<\/span> D12)<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9718\" title=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate3.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"1167\" height=\"293\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate3.png 1167w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate3-300x75.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate3-1024x257.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate3-768x193.png 768w\" sizes=\"(max-width: 1167px) 100vw, 1167px\" \/><\/p>\n<p>Apply <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-apply-formula-to-entire-column\/\" target=\"_blank\" rel=\"noopener\">the same formula<\/a> to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9719\" title=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate4.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"1056\" height=\"298\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate4.png 1056w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate4-300x85.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate4-1024x289.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate4-768x217.png 768w\" sizes=\"(max-width: 1056px) 100vw, 1056px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Go to <strong><em>Home &gt; Alignment &gt; Wrap Text<\/em> <\/strong>to show the text in multiple lines and you now have all of the results!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9720\" title=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate5.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"1041\" height=\"634\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate5.png 1041w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate5-300x183.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate5-1024x624.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Concatenate5-768x468.png 768w\" sizes=\"(max-width: 1041px) 100vw, 1041px\" \/><\/p>\n<p>This is how you can add a new line in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/new-formulas-in-office-365\/\" target=\"_blank\" rel=\"noopener\">excel concatenate formula<\/a>. Let&#8217;s look at the other two methods as well!<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"METHOD_2_Use_Ampersand_Sign\"><\/span><span style=\"color: #ff0000\"><strong>METHOD 2: <\/strong><\/span>Use <strong>&amp; (Ampersand)\u00a0<\/strong>Sign<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Instead of joining text using the Concatenate function, you can use the <strong>Ampersand (&amp;) sign<\/strong>. The &amp; sign works as a concatenation operator and <strong>clues together text<\/strong> for different cells as well as the char function.<\/p>\n<p>The formula to combine text with line break in the previous example with &amp; sign will be:<\/p>\n<h3 style=\"text-align: center\">=A9 &amp; <span style=\"color: #0000ff\">CHAR(10)<\/span> &amp; B9 &amp; <span style=\"color: #0000ff\">CHAR(10)<\/span> &amp; C9 &amp; <span style=\"color: #0000ff\">CHAR(10)<\/span> &amp; D9<\/h3>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-266.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18505\" title=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-266.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"839\" height=\"468\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-266.png 839w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-266-300x167.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-266-768x428.png 768w\" sizes=\"(max-width: 839px) 100vw, 839px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"METHOD_3_Use_TEXTJOIN_formula\"><\/span><span style=\"color: #ff0000\"><strong>METHOD 3: <\/strong><\/span>Use <strong>TEXTJOIN <\/strong>formula<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em>This function is available in Excel 2019 &amp; Office 365 only.<\/em><\/p>\n<p>Instead of selecting individuals cells and adding a CHAR function again and again in the formula, you can use the <strong>advanced versions of concatenate function<\/strong> &#8211; TEXTJOIN.<\/p>\n<p><strong>TEXTJOIN<\/strong> can be used to concatenate a range of cells using a delimiter.<\/p>\n<p>Excel requires three arguments for TEXTJOIN function:<\/p>\n<p>=TEXTJOIN(<span style=\"color: #0000ff\">delimiter<\/span>, <span style=\"color: #ff6600\">ignore_empty<\/span>, <span style=\"color: #339966\">text1, [text2], [text3],..<\/span>)<\/p>\n<ol>\n<li><strong>Delimiter<\/strong> &#8211; The character you need to insert in between each text.<\/li>\n<li><strong>Ignore_empty<\/strong> &#8211; It should be TRUE if you want to ignore empty cells and FALSE if you want to include the empty cells.<br \/>\n<em>By default, the value will be TRUE.<\/em><\/li>\n<li><strong>Text<\/strong> &#8211; Range of cells you want to combine.<\/li>\n<\/ol>\n<p>So, TEXTJOIN function in our example will look like this:<\/p>\n<h3 style=\"text-align: center\">=TEXTJOIN(CHAR(10), <span style=\"color: #0000ff\">TRUE<\/span>, A10:D10)<\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-267.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-18507\" title=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-267.png\" alt=\"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break\" width=\"838\" height=\"438\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-267.png 838w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-267-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/Screenshot-267-768x401.png 768w\" sizes=\"(max-width: 838px) 100vw, 838px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><a id=\"conclusion\"><\/a>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this article, you have gone through the 3 quick ways to<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\"> combine text<\/a> from different cells with a line break. You can use either a concatenate <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">function<\/a> or a &amp; sign or TEXTJOIN function.<\/p>\n<p><em>Make sure to apply Wrap Text to the cell when you are using <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-cells-in-excel\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a> Concatenate new line!<\/em><\/p>\n<div class=\"yuzo_related_post style-3\" data-version=\"5.12.68\">\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/combining-cell-ranges-in-excel\/\" target=\"_blank\" rel=\"noopener\">Concatenate &#8211; Combining Cell Ranges in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concat-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\">CONCAT Formula in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-in-excel\/\" target=\"_blank\" rel=\"noopener\">Concatenate in Excel &#8211; With and Without Separator<\/a><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Ever faced a situation when you are combining text from multiple cells with line break as separator? Looking for a new fix or hack for this? Keep reading! CONCATENATE Excel Function What does it do? Joins two or more text strings into one string. The item can be a text value, number, or cell reference. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33504,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"3 Quick &amp; Easy ways to Concatenate Excel With A Line Break","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[553,3,14],"tags":[69,669,43,70,670],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1116"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1116"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1116\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33504"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}