spot_img

Line Break

 

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.

Long Text String

2. Double click cell A1.

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

Cursor

4. Press Alt + Enter.

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

Increase Column Width

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

Result:

Line Break in Excel

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.

Concatenation with Line Breaks

Note: don’t forget to enable text wrapping.

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

Remove Multiple Line Breaks

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

spot_img
Previous articleHow to use GETPIVOTDATA in Excel
Next articleHow to Lock Cells in Excel