Microsoft: How to Add a Line Break in a Cell with Excel Formula

To add a line break in a cell, you need to add the following command into the formula:
& CHAR(10)

After that, you need to turn on wrap text for that particular cell.

For example:
=”Total amount is: ” & CHAR(10) & SUM(C1:C6)