View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default 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.