Insert Carriage Return in Formula

I am trying to combine a list of names from different cells into 1 cell with a carriage return between each name so the names appear vertically like:

Michaelangelo
Ann
Bob

And not what I would get if I just change the column width:

Michaelangelo
Ann Bob

I tried using =A1&Char(13)&B1&Char(13) but that didn't work. (I tried all non-printing characters I think.) Suggestions? Thanks.

Thanks for the advice.

I tried it with Char(#) where # = 1 - 255. When # = a non-keyboard character, all I got was a small square between the names. But thanks to your advice, I tried something else, too...

I forgot to format the spreadsheet cells to "wrap text".
Calman

I tried this and it worked perfectly. Thanks for posting.