In Excel, you can insert a line break within a formula to display content on multiple lines inside a single cell. This is useful for formatting text, organizing data, and making your spreadsheet more readable.
Using the CHAR Function
To insert a line break in Excel, use the CHAR(10) function for Windows or CHAR(13) for Mac.
Example Formula
If you have text in cells A1 and B1 and want to join them with a line break, use this formula:
=A1 & CHAR(10) & B1
Steps to Apply Line Breaks in Excel
- Enter the formula in a cell where you want the line break.
- Press Enter.
- Select the cell and go to the Home tab.
- Click on Wrap Text in the Alignment section to enable multi-line display.
Alternative Method: Using CONCATENATE or TEXTJOIN
If you are using an older version of Excel, you can use CONCATENATE:
=CONCATENATE(A1, CHAR(10), B1)
For newer versions (Excel 2016 and later), use TEXTJOIN to join multiple cells with a line break:
=TEXTJOIN(CHAR(10), TRUE, A1, B1, C1)
Using line breaks in Excel formulas helps make data more readable, especially when dealing with addresses, reports, or structured text. Just remember to enable Wrap Text for the breaks to be visible.