Test with CHAR Codes

[saileagleswings]

Text including the line feed character does not show line feed.  or example "aaa" & CHAR(13) & "bbb"  displays as aaabbb in the cell,   not as   

aaa

bbb

If I copy the cell and paste as value, the line feed still does break the line.  However, if I copy the text to word  the text displays as intended

aaa

bbb

What is wrong?   Using EXCEL 2016

[#2]

@saileagleswings CHAR(13) is Carriage Return and CHAR(10) is Line Feed (which are often used together). Try ="aaa"&CHAR(10)&"bbb", then apply Wrap Text formatting to the cell in order to display the desired results.