CHAR and CODE Function On ExcelSanyasi
Excel Mantra....
Hi Friends,
With the help of Char and Code Function you can Add a line break with a formula...
In the example shown the formula in E4 is:
=B4&CHAR(10)&C4&CHAR(10)&D4
How this formula works
This formula "glues together" the pieces of text that appear in B4, C4, and D4 using the ampersand (&) which is the concatenation operator in Excel.