View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default How do I start new line when concatenating text strings in excel?

=A2&CHAR(10)&D2

Biff

"Max" wrote in message
...
How do I add a command to start a new line when concatenating text strings
in
excel when referencing text cells?
e.g. cell A5 should contain =A2&?command?&D2 (Cell A5 is formatted for
word wrap)