< Go Back

Add a line break with a formula

You can add a line break using a formula in Excel. This is done by combining the CHAR function with the concatenation operator (&).

Formula

The generic formula syntax for adding a line break with a formula in Excel is:

="text"&CHAR(10)&"text"

OR

=cell_ref&CHAR(10)&cell_ref

Explanation

The formula joins together the individual text value or that is seen in cell references like E8, F8 and G8 using “&”, the concatenation operator in Microsoft Excel.

The character code used in the CHAR function varies depending on the platform used. 10 is used on Windows operating system while 13 is used on Macintosh (Mac) operating system. The formula returns with adding a line break between these concatenated values in the formula.

Example

In below image, we have text values in E8, F8 and G8 and we want to join these values adding a line break with a formula in a cell. The formula in cell H8 highlighted as shown in the screenshot is:

=E8&CHAR(10)&F8&CHAR(10)&G8

The formula returns the result with a line break

Luke mason¬
1567, Anders Drive¬
Houston, TX, 24390

Note: Wrap text must be enabled when using a line break formula.

Figure 1. Adding a line break with a formula

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar