How to add a line break to the output of a formula in Excel?

Use this formula:

    =UPPER($B$8)& " " & PROPER($C$8) & " &" & CHAR(10) & UPPER($B$9) & " " & PROPER($C$9)

and enable text wrapping in the cell with the formula:

or

EDIT#1:

There are four things at issue here:

• Text wrapping must be enabled in the formula cell
• the column must be wide enough to prevent "accidental" line-breaks
• the CHAR(10) should be inserted where YOU want the line-breaks
• the row height may need to be adjusted manually

For example

="James" & CHAR(10)  & "Ravenswood"

EDIT#2

Of course if the cell does not contain a formula, but only typed text then using Alt+Enter at the insertion point:

1. automatically inserts the ASCII-10
2. automatically turns on Text wrapping
3. automatically adjusts the row height

Add CHAR(13) (that works for me, if not works for you try char(10)) AND enable text wrapping in the cell, otherwise new line character won't have effect.