View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AB[_2_] AB[_2_] is offline
external usenet poster
 
Posts: 236
Default 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.