In the example shown, we want to write the text from cell A3, B3, and C3 with line breaks in D3. The above-written formula glues the text that appears in A2, B2, and C2 using the ampersand which is the concatenation operator in MS Excel. In the example shown, we want to write the text from cell A2, B2, and C2 with line breaks in D2. Here, we have some examples to explain the working of this formula. In the above-written formula to add a line break, we use the concatenation operator with the CHAR function. ![]() In this case, we have to use a formula to insert the line break. When we have to insert line breaks in many cells in Excel then we can not use a keyboard shortcut.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |