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, ...
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.