Forcing a line feed in the middle of a string
 

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.

Forcing a line feed in the middle of a string
 

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).

"dhstein" wrote in message
...
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.

Forcing a line feed in the middle of a string
 

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 wrote:

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.

--

Dave Peterson

Forcing a line feed in the middle of a string
 

AB, Dave,

Thanks.



"Dave Peterson" wrote:

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 wrote:

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.

--

Dave Peterson