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.
Double click on a cell that contains a formula you want to add a line break to.
Click where you want to implement the line break in the formula.
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.
The line break can now be seen in the formula bar separating the two different parts of the formula.
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.
Click on the cell you want to change then edit the text in the formula bar.
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"
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.
