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
|