In Excel, if I have two lines in A1:
but if I go over to A2 and type
=lower(A1), I get:
How can I preserve the newline between Hello and World?
Oddly enough, the newline is still there in A2, but the formatting of the cell is not showing it. If you click on A1, click
I don't think you can apply the right format as part of the formula though