Line Feed means moving the cursor to the beginning of the next line But remember to insert the line break in MS Excel first, we have to enable the Wrap Text otherwise, the CHAR function will make no changes in the result. Thus the character function in this formula combines the text that appears in A5, B5, and C5, and we get the result.ĪSCII stands for American Standard Code for Information Interchange. For this, enable the Wrap Text first and then use the formula “=A5&CHAR(10)&B5&CHAR(10)&C5”. In this example shown, we want to write the text from cell A5, B5, and C5 with line breaks in D5. Thus the character function in this formula combines the text that appears in A4, B4, and C4, and we get the result. Here, we have some examples to explain the working of this formula. CHAR function returns the result based on the ASCII code, which is a character code. We use the concatenation operator with the CHAR function in the above-written formula to add a line break. In this case, we have to use a formula to insert the line break. We cannot use a keyboard shortcut when we have to insert line breaks in many Excel cells. In that case, we use a formula to add a line break. But when we have to do the same in many cells, this method is time-consuming and inefficient. Here, we have inserted the line break after five digits of Mobile no. For example, suppose we want to add a line break after the second “m” in cell A3.įor this, we have to double click the cell A3 and bring the cursor after the second “m,” then press Alt+Enter. Similarly, we can insert line breaks in any cell. So, we double-click the cell and bring the cursor (after “a”) where we want the line break and press “ALT+ENTER.” Then we get a result. In this example, we want the line break in cell A5.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |