What are you using/doing to get a line feed? Alt-Enter gives you CHAR(10).

=1&CHAR(10)&CHAR(13)&2 with "Wrap text" turned on displays 1 and 2 on separate lines. The character count (LEN) is four (4).

The formula: =CODE(MID(_Text,2,1))&CODE(MID(_Text,3,1)) displays 1013 (as text) due to the MID function.


Regards, TMS