Forum Discussion
Test with CHAR Codes
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
1 Reply
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.
