How do you enter a carriage return or
CHAR(13) in a worksheet cell manually ? I'm not talking about a line feed or
I've seen this in a file and the carriage return had a very weird effect on the cell contents, but I can't reproduce it manually.
There are very good answers about how to enter a line feed in an Excel worksheet cell, and actually one of them gave me an idea how to achieve what I wanted in the first place:
=A1&CHAR(13)&A2 'Then copy cell + paste values only back again.
I'll accept the one that updates their content to reflect this. However, it'd be nice to know whether there's an equivalent of Alt + Return to type a carriage return.