Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Test with CHAR Codes

Copper Contributor

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.