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