In this article we will show you how to add a line break to any formula in google sheets. Simply follow the steps below:

‍

For this demonstration a sample sheet was created, access and follow along by clicking this link.

‍

Add a Line Break to a Formula in Google Sheets

1. Double click on the cell you want to enter the formula.

‍

Double click on a cell that contains a formula you want to add a line break to.

‍

2. Click where you want the line break to go in the formula 

‍

Click where you want to implement the line break in the formula.

‍

3. Click Ctrl + Enter (for Windows) or Cmd ⌘ + Return (for Mac) to Create a Line Break 

‍

With the text cursor in position, hold and click Ctrl + enter (for Windows) or cmd ⌘ + return (for Mac) to create the line break in the formula.

‍

4. Press Enter to see results 

‍

The line break can now be seen in the formula bar separating the two different parts of the formula.

‍

Add a Line Break to a Formula in Google Sheets with the CHAR Function. 

‍

The CHAR function allows you to use Unicode characters. In this example we will insert a line break into our formula using the Unicode character 10 which signifies a line break.

‍

1. Click on a cell you want to add a formula line break to and click the Formula Bar to edit

Click on the cell you want to change then edit the text in the formula bar. 

‍

 2.Enter the formula ="Value"&CHAR(10)&"Value”... 

‍

In the formula bar, enter the CHAR line break formula in the format below:

="Value"&CHAR(10)&"Value”...

‍

Formula breakdown:

‍

=: Activates the formula.

‍

“: An open quotation must follow the = symbol to activate the formula 

‍

Value: This is the text or numerical contents of your cell that will be separated by the line breaks. These individual segments must begin and end with quotation marks, failure to add these will result in an error message in the cell.

‍

“: Closed quotation symbols to surround the value.

‍

&CHAR(10)&: This is the CHAR function and the number 10 in brackets is the line break designation, this must be started and ended with the & symbol.

‍

Repeat this format for all values that you need to add the line break to. For our example, the completed formula is shown below:

‍

="The Brick"&CHAR(10)&"House, White"&CHAR(10)&"Drive.,"&CHAR(10)&"UK"

‍

3. Press Enter to see the result

‍

The formula has been added and the line breaks are now present in the cell. Again, the height of all cells in the entire row will have been increased because of these changes. 

We hope this article has helped you and given you a better understanding of the line break formula in Google Sheets. You might also like our articles on how to enter a new line in Google Sheets and what people chips are.

To optimize your workflow, we recommend reading our guide on how to send an email when a Google Sheet is updated and trying our software for setting up a dental appointment reminder!