Forcing a line feed in the middle of a string

[dhstein]

I have a cell like this:
=AT4&" "&AU4&" "&AT5&" "&AU5&" "&AT6&" "&AU6

This concatenates some text in a cell. I'd like to force a line feed after
the 2nd and 4th parameter for formatting purposes. I tried & char(13) & but
that didn't work. I appreciate any help on this.

 

[AB]

I usually just insert:
&"{Alt+Enter}"&

just for clarity you press Alt+Enter and not type it there.
Make sure that the cell that has this formula is formatted as Wrap Text (in
format cell).

 

[Dave Peterson]

Try chr(10) and make sure you set the format to wrap text--else you'll see a
little square in your cell.

=at4&chr(10)&...

 

[dhstein]

AB, Dave,

Thanks.

Try chr(10) and make sure you set the format to wrap text--else you'll see a
little square in your cell.

=at4&chr(10)&...