19
Excel Formulas to Add a Line Break ~ A Complete Tutorial!!
It’s easy to add a line break when you’re typing in an Excel worksheet. Just click where you want the line break, and press Alt + Enter. But how can you add line break in Excel using the formula? Today I introduce you to some formulas to solve this problem. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
![](https://res.cloudinary.com/practicaldev/image/fetch/s--zaf4muUH--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/05/Add-a-line-break-with-formula.png)
- You can use the below formula to add a line break in a cell.
=”text”&CHAR(10)&”text”
- CHAR – In Excel, the CHAR Function refers to the letters used in a word or a text string.
- Text – It represents the input text values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Refer to the below example image.
- First, we will enter the input values in Column B , Column C , and Column D.
- Now we have to join these text values with a line break.
![](https://res.cloudinary.com/practicaldev/image/fetch/s--a8hUdZnH--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-60.png)
- Select any cell and type the above-given formula.
![](https://res.cloudinary.com/practicaldev/image/fetch/s--VlgSc2vX--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-107.png)
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
![](https://res.cloudinary.com/practicaldev/image/fetch/s--dpCcKb1q--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://geekexcel.com/wp-content/uploads/2021/05/Result1-3.png)
Here, we have described how to add a line break with a formula in Excel. Hope you like this article. Please feel free to state your query or feedback for the above article.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
19