This Excel concatenate new line formula example helps you:
- Join 2 strings;
- While inserting a line break (new line).
Table of Contents
Excel Concatenate New Line Formula Template
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-concatenate-new-line/
=String1&CHAR(10)&String2
For these purposes, String1 and String2 are the strings you concatenate.
Excel Concatenate New Line Example Formula
The Excel concatenate new line example formula below:
- Joins the strings stored in cells B6 and B7;
- While inserting a line break (new line).
'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/excel-concatenate-new-line/
=B6&CHAR(10)&B7
The image at the top of this post shows the results I obtain with this Excel concatenate new line example formula. I use the Wrap Text button in the Home tab of the Ribbon to wrap the text.
Excel Concatenate New Line Explanation
The CHAR function returns a character specified by a code number. Code 10 (CHAR(10)) returns a line break.
Therefore, use the CHAR function and code 10 (CHAR(10)) to insert a line break (add a new line) when:
- Concatenating text; and
- Creating an Excel concatenate new line formula.
When creating an Excel concatenate new line formula, wrap the text (use the Wrap Text button in the Home tab of the Ribbon) to ensure Excel displays the multiple lines.
The ampersand text concatenation operator (&):
- Concatenates strings; and
- Returns a single string with the concatenated items.
The ampersand text concatenation operator (&) is not the only way to concatenate items. You can find more Excel concatenate formula examples in the More Excel Concatenate Formula Examples section.
More Excel Concatenate Formula Examples
This formula example is part of a more comprehensive series of Excel concatenate formula examples.
- Excel Concatenate Strings: Click here to open.
- Excel Concatenate Number and String: Click here to open.
- Excel Concatenate Date: Click here to open.
- Excel Concatenate with Space: Click here to open.
- Excel Concatenate New Line: Click here to open.
- Excel Concatenate Double Quote: Click here to open.
- Excel Concatenate Multiple Cells with Comma: Click here to open.
More Excel Training Materials and Resources
You can find more Excel Tutorials (including other formula examples) in the organized Tutorials Archive: Click here to visit the Archives.
If you want to ease all your operations and processes, you may be interested in Someka's ready-to-use Excel and Google Sheets templates. Someka's template collections cover, among others:
- Project Management;
- Human Resources;
- Sales and Marketing;
- Inventory Management;
- Calendars and Timesheets;
- Budgets; and
- Invoices.
Click here to learn more about Someka's Excel and Google Sheets templates