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.
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.
Next Chapter: Print