How to put a Carriage Return in Excel Cell

[RemingtonSteel]

Hello!
How can I concatenate 2 cells with a carriage return between them?

Manually, I know that it can be done by ALT+Enter.
However, I need to make a formula so I can save it on a single cell (new cell contains 1st cell + carriage return + 2nd cell).

Thanks!
Gene

 

[AnotherHiggins]

=A1 & char(13) & B1

Char(13) is Carriage Return, Char(10) is New Line/Line Feed.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

Hi

As you type, you can also use alt+enter to wrap the text.

You must also FORMAT the cell alignment to WRAP the text.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}