![]() You can also use the CONCAT formula instead of using the ampersand (&) symbol: =CONCAT(A2,CHAR(10),B2,CHAR(10),C2) By placing the line feed where you want the line break, we are forcing the formula to break the line in the formula result. ![]() ![]() CHAR(10) uses the ASCII code which returns a line feed. ![]() The above formula uses CHAR(10) to add the line break as a part of the result. This can be useful when you have different cells that you want to combine and add a line break so that each part is in a different line.īelow is an example where I have used a formula to combined different parts of an address and have added a line break in each part.īelow is the formula that adds a line break within the formula result: =A2&CHAR(10)&B2&(CHAR(10)&C2) You can add a line break as a part of the formula result. But if you have to do this a lot of cells, you can use the other methods covered later in this tutorial. The keyboard shortcut is a quick way to add a line break if you only have to do this for a few cells. ‘Wrap Text’ option is available in the Home tab in the ribbon. In case it’s is not applied, you will see all the text in a single cell (even if you have the line break). Note that you need the cell to be in the ‘Wrap text’ mode to see the content appear in the next line.
0 Comments
Leave a Reply. |