Line Break in Excel

You can insert a line break in Excel by pressing Alt + Enter. When concatenating strings, use CHAR(10) to insert a line break.

To insert a line break, execute the following steps.

1. For example, enter a long text string in cell A1.

2. Double click cell A1.

3. Place your cursor at the location where you want the line to break.

4. Press Alt + Enter.

5. Click on the right border of the column A header and drag the separator to increase the column width.

6. Double click the bottom border of the row 1 header to automatically adjust the row height.

Result:

Note: to remove a line break, double click a cell, place your cursor at the beginning of the line and press Backspace.

7. When concatenating strings, use CHAR(10) to insert a line break. For example, the address below contains two line breaks. Use the & operator to join strings.

Note: don't forget to enable text wrapping.

8. To quickly remove multiple line breaks in Excel, use the SUBSTITUTE function as shown below.

Explanation: this formula replaces all line breaks with a comma and a space.

If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.